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