I'm looking to generate rows between data.
Currently what i have is
Person | Month | Data |
Person 1 | 1 | X |
Person 1 | 6 | X |
Person 1 | 7 | X |
Person 1 | 8 | X |
Person 1 | 9 | X |
Person 1 | 10 | X |
Person 1 | 11 | X |
Person 1 | 12 | X |
Person 2 | 1 | X |
Person 2 | 6 | X |
Person 2 | 7 | X |
Person 2 | 8 | X |
Person 2 | 9 | X |
Person 2 | 10 | X |
Person 2 | 11 | X |
But I want to make it look like
Person | Month | Data |
Person 1 | 1 | X |
Person 1 | 2 | null |
Person 1 | 3 | null |
Person 1 | 4 | null |
Person 1 | 5 | null |
Person 1 | 6 | X |
Person 1 | 7 | X |
Person 1 | 8 | X |
Person 1 | 9 | X |
Person 1 | 10 | X |
Person 1 | 11 | X |
Person 1 | 12 | X |
Person 2 | 1 | X |
Person 2 | 2 | null |
Person 2 | 3 | null |
Person 2 | 4 | null |
Person 2 | 5 | null |
Person 2 | 6 | X |
Person 2 | 7 | X |
Person 2 | 8 | X |
Person 2 | 9 | X |
Person 2 | 10 | X |
Person 2 | 11 | X |
Person 2 | 12 | null |
Solved! Go to Solution.
Hi @rickydata ,
You can utilize the generate rows and a batch macro to achieve your desired outcome.
This one is good for when you have a single field, but within the scope of my data are several fields. Thanks
This one is great! thanks. Simple and can expand with data with multiple fields.