Help formatting horizontally

[lwilt]

What would be the best solution to format this information horizontally?

ItmItm AllQP
AK18025AK1802569
AK18025128.5
AK18025248
AK18025367.25
AB411FIRAB411FIR354
AB411FIR652
AB411FIR1250
AB411FIR2448
AE120AUSAE120AUS360
AE120AUS656.25
AE120AUS1253.13
AE120AUS2450
AY521AY5213169.75
AY5216162.5
AY5219159
AY52115156
AY522AY5223183.5
AY5226179
AY5229169
AY52215163


so for example:
AY522 3 183.5 6 179 9 169....

tried transposing the data but it didn't work at all and since it's Friday afternoon I'm struggling a bit today.

please help

 

[lwilt]

Itm Itm All Q P
AK18025 AK18025 6 9
AK18025 12 8.5
AK18025 24 8
AK18025 36 7.25
AB411FIR AB411FIR 3 54
AB411FIR 6 52
AB411FIR 12 50
AB411FIR 24 48
AE120AUS AE120AUS 3 60
AE120AUS 6 56.25
AE120AUS 12 53.13
AE120AUS 24 50
AY521 AY521 3 169.75
AY521 6 162.5
AY521 9 159
AY521 15 156
AY522 AY522 3 183.5
AY522 6 179
AY522 9 169
AY522 15 163


not wanting to copy correctly so heres another shot

 

[lwilt]

I want it to go to a new row at each change in Itm

 

[azumi]

try to post you sample workbook and type manually for the expected results

 

[lwilt]

uploaded the file...hopefully someone can help me

 

[Deepak]

Hi,

It's still quite unclear. Pls take liberty to explain more about your goal.

 

[lwilt]

never mind....was able to get help with a macro to do what I needed