Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page convert columns into rows
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2016, 04:54 AM
RayK RayK is offline convert columns into rows Mac OS X convert columns into rows Office for Mac 2011
Novice
convert columns into rows 		 
Join Date: Feb 2016
Posts: 5
RayK is on a distinguished road
Default convert columns into rows

I have a a single row with multiple columns of data.

How do I turn it into a single column with multiple rows?
Reply With Quote
  #2  
Old 02-09-2016, 05:49 AM
xor xor is offline convert columns into rows Windows 10 convert columns into rows Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If you have your data in row 1:

=INDEX($1:$1,,ROWS($1:1))
Reply With Quote
  #3  
Old 02-09-2016, 06:08 AM
RayK RayK is offline convert columns into rows Mac OS X convert columns into rows Office for Mac 2011
Novice
convert columns into rows 		 
Join Date: Feb 2016
Posts: 5
RayK is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
If you have your data in row 1:

=INDEX($1:$1,,ROWS($1:1))
Thank you. That worked perfectly.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert columns into rows Rows to Columns with Every Other Row Formula dlucius Excel 1 12-21-2015 07:10 PM
Moving from Rows to Columns jimmydd2121 Excel 1 06-02-2014 09:05 AM
convert columns into rows Stack columns into rows stellag09 Excel 1 04-23-2014 03:26 AM
convert columns into rows Changing rows into columns paapachak Word Tables 8 01-06-2014 02:44 PM
convert columns into rows Rows to Columns kyakobi Excel 5 12-07-2010 03:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:50 AM.

Contact Us - Privacy Statement - Top

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