Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2013, 10:12 AM
moishy moishy is offline Split one column to several columns Windows XP Split one column to several columns Office 2003
Novice
Split one column to several columns
 
Join Date: Feb 2012
Posts: 4
moishy is on a distinguished road
Default Split one column to several columns

Hi,



I'm looking for a way to split one column with several hundred rows, to several rows containing each 100 rows.

All advice will be appreciated.
Reply With Quote
  #2  
Old 02-01-2013, 12:50 AM
macropod's Avatar
macropod macropod is offline Split one column to several columns Windows 7 64bit Split one column to several columns Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,232
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

You could insert a new worksheet and, on that, insert a formula like:
=OFFSET(Sheet1!$A$1,(COLUMN()-1)*50+ROW()-1,)
where '50' is the number of rows you want to use on that worksheet. Simply copy the formula down to your last row (50 in the example), then across as far as needed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columns. How to move the left column so it's to the right of the 'right' column ? Vit Word 9 11-21-2012 12:57 PM
Independent, Split Columns in Word? dave0620 Word 3 12-12-2011 07:15 PM
Fill column with other columns info Novice Excel Programming 10 07-28-2011 09:45 AM
how to create two columns based on a certain criterior from the original two column? where_pc Excel 3 06-13-2011 10:39 AM
Split one column to several columns How to expand one column into two columns? Jamal NUMAN Excel 1 01-12-2011 07:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:28 PM.


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