+ Reply to Thread
Results 1 to 1 of 1

Formula to automatically move/copy data from rows to columns

  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Saint Cloud, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    5

    Question Formula to automatically move/copy data from rows to columns

    I have a spreadsheet with data down column "a" only (names, addresses, etc). I want to move the data so it goes across the page under "B" "C" "D" etc.... It needs to be the actual data (text), not a formula "repeating" the data....

    Example:
    Column A
    Row 1 Laura M. Smith
    Row 2 1234 Joy Lane
    Row 3 Somewhere
    Row 4 CA
    Row 5 99999

    Need it to be:
    Column A Column B Column C Column D Column E
    Laura M. Smith 1234 Joy Lane Somewhere CA 99999
    Last edited by thchughesmathews; 02-06-2012 at 12:02 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1