arrange data

[Suri]

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]

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]

Thank you so much. Saved me lot of time...

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