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 !
Bookmarks