Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Apr 3, 2012, 10:17 PM   #1
jent
macrumors 6502a
 
Join Date: Mar 2010
Converting rows to columns in Excel

I am copying and pasting information about some conferences from a large list of panels. When I find conferences that I am interested in, I copy and paste them into a big Word document, but I figure I can compare them more easily in an Excel spreadsheet.

Each entry is five lines. Here's a sample entry:
Code:
Session ID:     1234
Track Code:     ABC
Session Name:   How to Change the World
Day:            Thursday
Time:           12:30 pm - 2:15 pm
What I'd like to do is convert the items in the first column into the top row of an Excel spreadsheet. This way, I can look at one single column for a list of dozens of session names and look down a single column to see what times they take place.

Is there an easy way to do this in Excel when the data I'm getting in the first place is in the above format? Many thanks!
jent is offline   1 Reply With Quote
Old Apr 3, 2012, 10:21 PM   #2
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by jent View Post
What I'd like to do is convert the items in the first column into the top row of an Excel spreadsheet.
  1. Select the entire range.
  2. Command-C to copy
  3. Click on a cell outside the copied range as your destination.
  4. Right-click and select "Paste Special"
  5. Check the "Transpose" box and click OK.
GGJstudios is offline   2 Reply With Quote
Old Apr 4, 2012, 09:48 AM   #3
jent
Thread Starter
macrumors 6502a
 
Join Date: Mar 2010
Thank you, GGJstudios! It worked like a charm.
jent is offline   0 Reply With Quote
Old Apr 4, 2012, 10:08 AM   #4
hafr
Banned
 
Join Date: Sep 2011
A small addition to the answer: the keyboard shortcut for paste special is ctrl+cmd+V
hafr is offline   2 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Tags
columns, convert, excel, rows, text

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Bootcamp vs. VMWare Fusion 6 vs. Parallels 9: Excel w/large data sets (250,000+ rows) smileman Windows, Linux & Others on the Mac 6 Jan 6, 2014 06:13 AM
How do I create tables with multiple columns and rows? moonman239 iPhone/iPad Programming 4 Nov 10, 2013 06:45 AM
Any way to access "hidden" columns from an Excel spreadsheet? therealseebs Mac Applications and Mac App Store 1 May 2, 2013 05:17 PM
Way to show certain rows/columns in another worksheet? jent Mac Applications and Mac App Store 4 Mar 28, 2013 10:39 PM
iPhone: How to get five rows (not columns) in iOS 5.1.1? Qwertylizer Jailbreaks and iOS Hacks 3 Sep 15, 2012 10:01 AM

Forum Jump

All times are GMT -5. The time now is 01:12 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC