| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
make table to row column
Hi,
I have a really big table with date as heading : People 11/07 12/07 13/07 john 1 2 5 wolf 5 4 7 how can I make to be seen as: People Date Number john 11/07 1 john 12/07 2 john 13/07 5 wolf 11/07 5 wolf 12/07 4 wolf 13/07 7 the spreadsheet is to long so it is not possible to do it by copy and paste, I also want to keep the link anybody can help? I really appreciate that thanks Nader |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
make table to row column
You need to write a macro or a formula. What you actually choose will depend
on the detail of the data. -- Cheers, Shane Devenshire "nader" wrote: Hi, I have a really big table with date as heading : People 11/07 12/07 13/07 john 1 2 5 wolf 5 4 7 how can I make to be seen as: People Date Number john 11/07 1 john 12/07 2 john 13/07 5 wolf 11/07 5 wolf 12/07 4 wolf 13/07 7 the spreadsheet is to long so it is not possible to do it by copy and paste, I also want to keep the link anybody can help? I really appreciate that thanks Nader |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
make table to row column
nader -
John Walkenbach shows how to do this (using an Excel pivot table) at http://www.j-walk.com/ss/excel/usertips/tip068.htm - Mike http://www.mikemiddleton.com "nader" wrote in message oups.com... Hi, I have a really big table with date as heading : People 11/07 12/07 13/07 john 1 2 5 wolf 5 4 7 how can I make to be seen as: People Date Number john 11/07 1 john 12/07 2 john 13/07 5 wolf 11/07 5 wolf 12/07 4 wolf 13/07 7 the spreadsheet is to long so it is not possible to do it by copy and paste, I also want to keep the link anybody can help? I really appreciate that thanks Nader |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
Linear Mode
