#1
|
|||
|
|||
Stack columns into rows
hello, I have a table of 300 columns. I need to stack the columns into rows. I need to keep the first 5 columns the same. Would appreciate help with a macro or better yet a sample workbook with a built=in macro. I used to have it, but moved jobs and lost it. Any help is greatly appreciated. |
#2
|
||||
|
||||
You will need to provide a lot more detail about your current table and its proposed layout. Like how many rows does it have, whether all rows have the same # of columns, how many columns the output should have (I'm guessing 5, but you don't actually say), whether the data to be added is to be interspersed with the existing data in the destination columns, or are to follow them, etc.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing rows into columns | paapachak | Word Tables | 8 | 01-06-2014 02:44 PM |
Adding columns in specific rows only | mhays | Excel | 5 | 01-17-2012 09:13 AM |
How do I stack columns of data on top of each other? | Snvlsfoal | Excel | 1 | 07-29-2011 10:16 AM |
Rows to Columns | kyakobi | Excel | 5 | 12-07-2010 03:12 PM |
Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |