+ Reply to Thread
Results 1 to 6 of 6

Horizontal Data to Vertical

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Appleton, WI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Horizontal Data to Vertical

    I am trying to take a large amount of data that is listed vertically in groups of 16 lines seperated by 2 empty lines and have it shown horizontally into 16 columns.
    I've tried the transpose function, which would work if I didn't have about 5500 lines of data. I've also tried a formula that kind of worked, but it put the verical data into one cell and not individual columns. Is there any way to do this? It seems like it should be simple but I can't get my desired result. I've attached the file, for reference.

    Thanks for any help!
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,255

    Re: Horizontal Data to Vertical

    In cell B2 of Combine Sheet you can try the formula:
    Please Login or Register  to view this content.
    and copy to right and down.

  3. #3
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Horizontal Data to Vertical

    So the Combined Sheet is where the data is housed?

    What is the end result you are wanting?

    you could loop through the data appending it to the first empty right column so you have a ton of columns.

    Are you using a macro to bring all this in together?

    I am confused as to what you are trying to accomplish I suppose.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  4. #4
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Horizontal Data to Vertical

    this is my solution.
    Attached Files Attached Files
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  5. #5
    Registered User
    Join Date
    01-13-2014
    Location
    Appleton, WI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post Re: Horizontal Data to Vertical

    I was able to use both solutions to get the desired results!

    I appreaciate the help

    Thanks

  6. #6
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Horizontal Data to Vertical

    This might work
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Horizontal data in vertical
    By ashfaquebwd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-10-2013, 03:50 AM
  2. convert data horizontal to vertical
    By vorabha in forum Excel General
    Replies: 8
    Last Post: 02-10-2013, 03:53 PM
  3. Vertical to Horizontal data help!
    By hbrown78 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2012, 09:57 PM
  4. [SOLVED] Data horizontal to vertical
    By sureshpunna in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-27-2012, 03:36 AM
  5. [SOLVED] Vertical to Horizontal data
    By trosasco in forum Excel General
    Replies: 5
    Last Post: 06-15-2012, 08:48 AM

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