Hi! This is my first time posting on Excel Forum but I'm excited to hear from you experts. I have almost no background in VBA but I need some help for a MACRO that I believe is possible to create based on my research online. Here what I need to figure out...
I have a table where the last few columns have numbers spread across the same row. The number of columns that contain numbers varies per row, so, some rows may have 20 columns with data and some with 2 or 3. These columns looks kind of like the following:
Column1 Column2 Column3 Column4......
2 3 5 77
Before these data columns is a column that states the number of columns with data fields populated in that row.
What I need to do is to make a macro that reads the number in this column (The column that defines the number of data columns in a row) and inserts those many rows below the original row, after which the the columns with the actual would be copied and transposed below the orignal row. To further explain this, imagine the column following the data fields shown above said "14". I would need the macro to read this number insert 14 blank rows below that row and copy the data from columns, transpose and paste, as shown below:
Column1
2
3
5
77
.
...
...
until all 14 rows are populated with data.
I found this discussion
http://www.excelforum.com/excel-prog...iple-rows.html
kinda helpful but totally clueless how I should go about this.
Any help will be much appreciated!
Thanks a lot!!
Bookmarks