grerealtime.blogg.se

Set the name of your source sheet in the code. Make sure to check the code to see where the columns and rows begin on the source sheet. Loop through the column groups one "ROW#" (your label) at a time, through all rows deep.Ĭopy the data to the target sheet, in the format you wantĮxample: data starts on row 2 of Target Sheet Identify how many columns are in each group.

Get the last row of the source sheet and the last column. As long as there are 4 columns in each Row group.

This will work over as many columns as you have.

I'm new to macro so hopefully I can make this automated otherwise I'm copying and pasting all of them manually. How can I make it happen using macro since there are ~20 "rows" and ~40 "positions" in my sheet. | 12 | Spaced | row2 | 0 | ingn | Spaced | | 12 | Spaced | row1 | 0 | ingo | Spaced | | position | bbnum | row | qty | Configuration | I want to use macro to transpose to look like this. | 12 | Spaced | ingo | Spaced | 0.00 | Spaced | ingn | Spaced | 0.00 | | 9 | Empty | inkf | Empty | 0.00 | Empty | inke | Empty | 0.00 | | 8 | Empty | inkf | Empty | 0.00 | Empty | inke | Empty | 0.00 | | 7 | Empty | inkq | Empty | 0.00 | Empty | inkp | Empty | 0.00 | | 6 | Empty | inkq | Empty | 0.00 | Empty | inkp | Empty | 0.00 | | 5 | Empty | inla | Empty | 0.00 | Empty | inkz | Empty | 0.00 | | 4 | Empty | inla | Empty | 0.00 | Empty | inkz | Empty | 0.00 | | 3 | NoFiber | | NoFiber | 0.00 | NoFiber | | NoFiber | 0.00 | | 2 | NoFiber | | NoFiber | 0.00 | NoFiber | | NoFiber | 0.00 | |position | item | Configuration | qty | item | Configuration | qty | Each "row" like row1 and row2 has a list of items, config, qty, and "rows" are sharing same "position".