Gloria1111
New Member
- Joined
- Jul 31, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi guys,
I have a spreadsheet with around 2000 rows of data and i need to transpose each row of data every n row, only that "n" is not fixed, and also to exclude the blanks.
I found a similar thread but it is only based on a fixed n row: VBA Transpose every nth row
How can i get it to transpose the row of data for Jan-June and skip the next "N" number of rows based on the indicated "N" value?
Example:
Original data
Desired result:
Any help/advice is greatly appreciated.
If my question is not clear, please let me know and i will see how i can rephrase or post a clearer example.
Thank you.
I have a spreadsheet with around 2000 rows of data and i need to transpose each row of data every n row, only that "n" is not fixed, and also to exclude the blanks.
I found a similar thread but it is only based on a fixed n row: VBA Transpose every nth row
How can i get it to transpose the row of data for Jan-June and skip the next "N" number of rows based on the indicated "N" value?
Example:
Original data
Name | Jan | Feb | Mar | Apr | May | June | N Value |
John | 123 | 24 | 22 | 2 | |||
John | |||||||
John | |||||||
Grace | 23 | 67 | 1 | ||||
Grace | |||||||
Jason | 400 | 646 | 23232 | 222 | 443 | 65 | 5 |
Jason | |||||||
Jason | |||||||
Jason | |||||||
Jason | |||||||
Jason |
Desired result:
Name | Jan |
John | 123 |
John | 24 |
John | 22 |
Grace | 23 |
Grace | 67 |
Jason | 400 |
Jason | 646 |
Jason | 23232 |
Jason | 222 |
Jason | 443 |
Jason | 65 |
Any help/advice is greatly appreciated.
If my question is not clear, please let me know and i will see how i can rephrase or post a clearer example.
Thank you.