Data Sorting Problem (Excel 2000)

[Kobus]

Hallo again

I have one problem for which I need some guidance as how to solve it.

I attach a workbook with 2 sheets. The one sheet contain the original data and the other the data in the format that it needs to be.

On the original data sheet you will notice that there are MTN numbers with more than one entry against it (in the blue section)

Each MTN needs to copy to the processed data, one line for each case where there are information written against it.
Then the price in the top row has to copy against each item as shown in the processed data sheet.

This is just a very small extract from the data I have to convert into this format. There are hundreds of rows and about 50 columns, I just reprodused a small section to explain the problem.

Are there code available top do this or can anybody point me in the right direction.

Thank you very much

[rory]

Hi,
Is there a set number of columns or does it vary each time you have to do this (I'm assuming this is not a one time job)?

[Kobus]

At this moment there are 32, but it is not always the same. 50 should be the maximum.

You are correct, it will be done at least once a month with a maximum of about 3 times per month.
Thank you

[rory]

Try the attached version - it contains a subroutine called ProcessData that will ouput to a sheet called ProcData. I have not done any formatting, just the basic data rearrangement, but that can be added if necessary.

[dcardno]

Damn - Rory beat me to it....

Output is to "FlatData," and routine must be run from initial data sheet. Now to compare to Rory's <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

[Kobus]

Rory & Dean

Thank you for your great work, this will save me hours and hours if not days of work per month. I do not know how I will solve all the problems without this Forum's help.

I realy appreciate it.

Thank you again