Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2014, 09:28 PM
stellag09 stellag09 is offline Stack columns into rows Windows 7 32bit Stack columns into rows Office 2010 32bit
Novice
Stack columns into rows
 
Join Date: Apr 2014
Posts: 1
stellag09 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-23-2014, 03:26 AM
macropod's Avatar
macropod macropod is offline Stack columns into rows Windows 7 32bit Stack columns into rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stack columns into rows 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
Stack columns into rows 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft