LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8
Default 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,

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Arrange Data for Chart Karen Charts and Charting in Excel 6 September 17th 08 06:32 PM
An Excel Formula know how to re-arrange the data wilchong via OfficeKB.com New Users to Excel 7 May 28th 08 04:29 AM
re-arrange cell data leonardoromero Excel Discussion (Misc queries) 3 February 21st 07 06:20 PM
how to split data into columns and arrange the resulting data jack Excel Discussion (Misc queries) 1 November 11th 05 11:20 PM
arrange data by criteria Jeff New Users to Excel 4 May 24th 05 07:57 PM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"