Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

arrange data

0 views
Skip to first unread message

Suri

unread,
Nov 23, 2009, 5:21:01 PM11/23/09
to

Hi,

I've got certain data in an excel sheet horizontally and vertically.
Eg

Product A Product B Product C
Sales xxxxxxx xxxxxx xxxxxx
Gross margin xxx xxx xxxxx
Marketing expenses xxxx xxx xxxxx
Selling expenses xxxxx xxxx xxxxxx
Admin expenses xxxxx xxxxx xxxxxx
Profit xx xx
xxxx

How would I change the format to see products vertically and data
horizontally?

Is there a formula?

Many Thanks,

John Calder

unread,
Nov 23, 2009, 6:23:03 PM11/23/09
to
Highlight your data table then copy.

Place the curser where you want to put your table.

Goto Edit then Paste Special

Click on Transpose and select OK

Cheers

Suri

unread,
Nov 23, 2009, 7:11:01 PM11/23/09
to

Thank you so much. Saved me lot of time...
0 new messages