Results 1 to 6 of 6

Move Multiple-Column Data to One Column (not Transpose)

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    3

    Move Multiple-Column Data to One Column (not Transpose)

    Greetings. Using Excel 2010. I have 100 customer orders running across 100 columns. Each order has 4 rows of data. I want to maintain the data being in rows but I would like to eventually export/copy+paste one long list to Word or similar. Example:

    CURRENTLY
    A1 B1 C1 D1 etc.
    A2 B2 C2 D2
    A3 B3 C3 D3
    A4 B4 C4 D4

    DESIRED
    A1
    A2
    A3
    A4

    B1
    B2
    B3
    B4

    C1
    C2
    C3
    C4

    D1
    D2
    D3
    D4

    etc.

    Any suggestions?
    Eric
    Last edited by CriticalEric; 05-03-2011 at 09:42 AM.

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