Loop & Sort

[chillster]

Hi,

I have a document were I have to change the places of each coloumns and rows around. For example we want on a new sheet the unique data from column D (description, first being BL12) to be on row F1 and the cells between (A1:E1) to be empty/merged, and from row A2:F2 the data from column H, I, J, K, E, F in that order.

Following this we want the data for BL13 on L1 and the data with BL13 to be formated as the previous BL but on the side.

Does anyone have an idea I could try?
Adding a dummy sheet due to sensitive information, the original document have over 5000 products.

[Olly]

Can you post an example of what your required output looks like?

[chillster]

In sheet2 is how we want it to look like, hope this helps.