| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Quasi Transpose / Stacking Columns
Appreciate any tips on doing the following matrix change:
Original Matrix Date Series 1 Series 2 Series 3 1/1/2005 23 45 99 1/2/2005 24 46 100 1/3/2005 20 40 101 1/4/2005 22 40 99 1/5/2005 25 46 98 New Matrix Date Series Data 1/1/2005 Series 1 23 1/2/2005 Series 1 24 1/3/2005 Series 1 20 1/4/2005 Series 1 22 1/5/2005 Series 1 25 1/1/2005 Series 2 45 1/2/2005 Series 2 46 1/3/2005 Series 2 40 1/4/2005 Series 2 40 1/5/2005 Series 2 46 1/1/2005 Series 3 99 1/2/2005 Series 3 100 1/3/2005 Series 3 101 1/4/2005 Series 3 99 1/5/2005 Series 3 98 Thanks in advance. Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
| how do I transpose columns and rows | Excel Discussion (Misc queries) | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
Threaded Mode
