Changing Headers to Row (1 Viewer)

[miguel vasquez]

Hi All,

I need help. I have a table with heading that I want to see them in rows. For example:
The way it is now:
Group 3 Group 4 Group 5
10.00 5.00 3.00
20.00 15.00 6.00

The way I want to see it:
Totals
Group 3 10.00 20.00 30.00
Group 4 5.00 15.00 20.00
Group 5 3.00 6.00 9.00

I would really appreciate your help. Thanks

 

[ajetrumpet]

you can do this with access, but the best way is to import into excel and shift the data that way, using the transpose function on the right click menu. it is way better off, and easier.

 

[neileg]

It looks like your data is not normalised (normalized). It will be much easier to handle (including your current issue) if you change to a normalised structure. Try Wikipedia for a start on what this is all about.