realignment of a table

melaurel · May 8th, 2002, 02:49 PM

I have a table organized so that months are down the left (rows) and the data associated with those months is across the (labeled) columns, can I easily rearrange my table so that the months read across the top and the labels down the left, and the data remains associated correctly? I'm sure that's a dummy question, lol, but so far all i can figure out is to re-enter all of the data manually, euwwwww!

[ This Message was edited by: melaurel on 2002-05-08 13:51 ]

Asala42 · May 8th, 2002, 02:52 PM

G'day,

Can you get away with a copy/edit/paste special/transpose?

Adam

melaurel · May 8th, 2002, 02:59 PM

ummmmm.... yes! Thank you very much!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 02:49 PM	#1
melaurel New Member Join Date: May 2002 Posts: 5	I have a table organized so that months are down the left (rows) and the data associated with those months is across the (labeled) columns, can I easily rearrange my table so that the months read across the top and the labels down the left, and the data remains associated correctly? I'm sure that's a dummy question, lol, but so far all i can figure out is to re-enter all of the data manually, euwwwww! [ This Message was edited by: melaurel on 2002-05-08 13:51 ]

May 8th, 2002, 02:52 PM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	G'day, Can you get away with a copy/edit/paste special/transpose? Adam

May 8th, 2002, 02:59 PM	#3
melaurel New Member Join Date: May 2002 Posts: 5	ummmmm.... yes! Thank you very much!