LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default how to change data from horizontal to be vertical (Excel 2003)

I got Bill of materials in showing Raw Materials usage in horizontal
like this
RM1 RM2 RM3 RM4 RM5
FG1 5 6 3 2
FG2 2 7 1
FG3 7 5 2

but I would like to change it to be vertical as follow

FG1 RM1 5
RM2 6
RM4 3
RM5 2
FG2 RM1 2
RM3 7
RM5 1
FG3 RM2 7
RM3 5
RM4 2

could you please advise how should we do

best rgds,
suwat u.
 
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 change data from horizontal to be vertical (Excel 2007) Suwat Upathambhakul (Thailand) Excel Discussion (Misc queries) 7 April 14th 09 06:58 AM
How do I change horizontal cells to vertical JMP Excel Discussion (Misc queries) 1 August 7th 08 09:40 PM
change table from vertical to horizontal widman Excel Discussion (Misc queries) 0 December 5th 06 02:21 PM
How to make Horizontal data go Vertical tx12345 Excel Worksheet Functions 10 December 24th 05 03:40 AM
How do I change my typing from horizontal to vertical chickaleeka Excel Worksheet Functions 2 December 12th 05 03:18 AM


All times are GMT +1. The time now is 02:14 AM.

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"