Transpose A Table in Access or Excel 1

[gall3on]

I'm not sure if this can be done in Access or Excel.

I have an Access table that gets updated from several queries. The finalized table needs to be displayed in a certain way for me to copy the data to a different Excel sheet.

Access Table:
ID ColA ColB ColC
Pink 5 3 2
Blue 4 9 0
Zero 6 8 3

Wanted Result:
Pink Blue Zero
ColA ColB ColC ColA ColB ColC ColA ColB ColC
5 3 2 4 9 0 6 8 3

And so on and so forth. It's like a transpose, but it's a group transpose. I'm not sure if I can do this via Access Report or if there's a way to do this in Excel.

 

[AnotherHiggins]

How many IDs (Pink, Blue, Zero, etc) do you have? I ask for two reasons.

- First there's the possible limitation. Excel, up until 2007, has a limit of 256 columns. Excel 2007 has 65,536 columns.

- More importantly is readability. This layout will be extremely difficult to read if you have more than a handful of IDs.

but if there aren't too many IDs, a Pivot Table can do this for you in a jiff.

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

Help us help you. Please read FAQ 181-2886 before posting.

 

[gall3on]

Oh duh me. Thanks! I comletely forgot I can manipulate it that way with Pivot Tables in Excel.