+ Reply to Thread
Results 1 to 2 of 2

Convert Horizontal data into a 'Cummulative' (one-column) Vertical List

  1. #1
    Registered User
    Join Date
    02-15-2012
    Location
    Florida, USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Convert Horizontal data into a 'Cummulative' (one-column) Vertical List

    Hi -
    I am only familiar with very simple macros, but I can't get this to work. I am hoping that I could get some ideas on how to go about it.

    I have data (400 rows) that looks like this: (23 columns in total): (for this example I am using only 2 rows and 5 columns = 10 rows in vertical)

    IN_0168 IN_0164 MH_0007 IN_0172 WCD3_03
    IN_0176 IN_0172 WCD3_03 WCD3_04 #N/A

    and I want it to look like this:

    IN_0168
    IN_0164
    MH_0007
    IN_0172
    WCD3_03
    IN_0176
    IN_0172
    WCD3_03
    WCD3_04
    #N/A

    This is what I was trying to do: (I know it doesn't work but, it would get you an idea of what I am after, I hope)

    For m = 2 To 5
    For n = 1 To 23
    For b = 2 To 100
    Sheets("Hierarchy").Select
    Cells(m, n).Select
    Selection.Copy
    Sheets("HierN_H2V").Select
    Cells(b, 1).Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=True
    Selection.End(xlDown).Select
    Next
    Next
    Next
    End Sub

    Thanks for Comments !

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Convert Horizontal data into a 'Cummulative' (one-column) Vertical List

    Hi

    Fistly, can you please edit your post and enclose your code with code tags
    Please Login or Register  to view this content.
    See if this works for you.
    Please Login or Register  to view this content.
    rylo

+ 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