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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Rank with If 6
How do I make a vertical report export into a vertical report? 3
Word created document; but would like to add "excell" style simple 3
Sumproduct issues. 1
concatenate entries from a column into a cell by logical AND withanother column 2
How to search a cell for last instance of repeating character anddelete to end of data 3
Calculation needed maybe a pivot table - Thank you 2
ActiveX warning message when adding signature 5

Back
Top