Excel - Split rows into columns

[Alliance]

Hi guys

Trying to do the following with some data.

I currently have the data listed in rows like the below image...

I want to split it into columns by the stock code as shown below...

Any ideas?

Cheers

 

[Alliance]

I think some sort of transpose marco would do it but it needs to keep everything sorted by column A - the stock code.

 

[ElliottRoss]

Hi

Have you tried using a Pivot table?

Regards
Elliott

 

[MikeJ]

Use the index function to drag the data out.

 

[DataExpert]

Hello,

Assuming that your 2 snapshots are on the same worksheet, copy the following formula into cell F2, and drag both down and accross. Should give you what you are looking for as long as your data is in the same format...

=OFFSET($C$2,(ROW()-2)*5+COLUMN()-6,0)

Give me a shout if you don't get what you were expecting.

Cheers

Ben