Hey all,
I un-versed in VBA or any type of coding, for that matter, but it looks like formulas won't for what I'm attempting to do. I'm trying to transpose a variable number of cells in a row into columns right beneath the first column. I've already pre-inserted the required number of rows beneath each of the rows I'm trying to transpose.
I'm actually working with columns O to W (8 columns total)
I'm trying to get from...
<tbody>
</tbody>
to...
<tbody>
</tbody>
Gotta do this for about 5,000 rows so any help would be appreciated! I can't imagine how many days this would take to finish manually.
-Drew
I un-versed in VBA or any type of coding, for that matter, but it looks like formulas won't for what I'm attempting to do. I'm trying to transpose a variable number of cells in a row into columns right beneath the first column. I've already pre-inserted the required number of rows beneath each of the rows I'm trying to transpose.
I'm actually working with columns O to W (8 columns total)
I'm trying to get from...
a | b | c | |
1 | 2 | ||
aa | bb | cc | dd |
<tbody>
</tbody>
to...
a | b | c | |
b | |||
c | |||
1 | 2 | ||
2 | |||
aa | bb | cc | dd |
bb | |||
cc | |||
dd |
<tbody>
</tbody>
Gotta do this for about 5,000 rows so any help would be appreciated! I can't imagine how many days this would take to finish manually.
-Drew