Thread: convert columns into rows
View Single Post
 
Old 02-09-2016, 06:08 AM
RayK RayK is offline Mac OS X Office for Mac 2011
Novice
  
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