Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
Hello All,
I have a report that has data in a Column based format (Left to right) that I need to convert into a linear format (up and down) and not sure that fastest way to accomplish this.
My data has column detail from Columns A:F, in in Columns G:AP there are ID's that I need to grab and create a duplicate of the row and enter each unique ID into column F. I did create a helper column in Column E that Counts how many values are in Columns G:AP.
Once the code runs it will clear all the values in columns G:AP since they have now been moved into Column F as unique rows.
Currently my report has 121 rows of data and for each row so will definitely need code to achieve this quickly.
Here is a mocked-up example of what I mean;
Current (I intentionally left columns B:E out of the grid for this example)
<tbody>
</tbody>
Expectation
<tbody>
</tbody>
Any help on this is appreciated.
I have a report that has data in a Column based format (Left to right) that I need to convert into a linear format (up and down) and not sure that fastest way to accomplish this.
My data has column detail from Columns A:F, in in Columns G:AP there are ID's that I need to grab and create a duplicate of the row and enter each unique ID into column F. I did create a helper column in Column E that Counts how many values are in Columns G:AP.
Once the code runs it will clear all the values in columns G:AP since they have now been moved into Column F as unique rows.
Currently my report has 121 rows of data and for each row so will definitely need code to achieve this quickly.
Here is a mocked-up example of what I mean;
Current (I intentionally left columns B:E out of the grid for this example)
Col A | Col E | Col F | ID1 | ID2 | ID3 | ID4 |
Name1 | 3 | Currently Blank | J1 | J2 | J3 | |
Name2 | 2 | Currently Blank | Z5 | Z10 |
<tbody>
</tbody>
Expectation
Col A | Col E | Col F | ID1 | ID2 | ID3 | ID4 |
Name 1 | 3 | J1 | ||||
Name 1 | 3 | J2 | ||||
Name 1 | 3 | J3 | ||||
Name 2 | 2 | Z5 | ||||
Name 2 | 2 | Z10 |
<tbody>
</tbody>
Any help on this is appreciated.