Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
arrange data
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, |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
arrange data
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" wrote: 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, |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
arrange data
Thank you so much. Saved me lot of time... "John Calder" wrote: 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" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Arrange Data for Chart | Charts and Charting in Excel | |||
An Excel Formula know how to re-arrange the data | New Users to Excel | |||
re-arrange cell data | Excel Discussion (Misc queries) | |||
how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
arrange data by criteria | New Users to Excel |