Re-ordering Data in Excel

[truitt20]

Currently this is how my data is set up:

ColA: ColB: ColC: ColD: ColE: ColF:
Broker Dec-05 Nov-05 Oct-05 Sep-05 Aug-05
ABN ASIA 29,908 14,999 5,697
BARCLAYS CAPITAL 88,509 152,304 90,262 24,011 2,928


but i would like to get it like this:

Column A: Col B: Col C:
ABN ASIA Dec-05 29,908
ABN ASIA Nov-05 14,999
ABN ASIA Oct-05 0
ABN ASIA Sep-05 5,697
ABN ASIA Aug-05 0
BARCLAYS CAPITAL Dec-05 88,509
BARCLAYS CAPITAL Nov-05 152,304
BARCLAYS CAPITAL Oct-05 90,262
BARCLAYS CAPITAL Sep-05 24,011
BARCLAYS CAPITAL Aug-05 2,928


Any way to automate this? I have over 350 Brokers I need to do this to.

thanks in advance

jt

 

[AnotherHiggins]

Have a look at Pivot Tables.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Hi,

NORMALIZE Your Table using the PivotTable Wizard faq68-5287

Skip,

_[red][/red]