arrange data

  • Thread starter Thread starter Suri
  • Start date Start date
S

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,
 
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
 
Thank you so much. Saved me lot of time...

John Calder said:
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
Click to expand...
 
Back
Top