Batch Macro Pivot Table

[brightonle]

Hello, I was wondering if anyone knew how to create a batch macro to get null record values to pivot to one record. I have program data along with activity data and underneath the program would be some null records that contain additional activity data. So for example if I had one null record it would add one additional activity to the specific record. I want to create a batch macro to do this however I am not sure how to create one. I attached the input and output that I want. Thanks!

[binuacs]

@brightonle workflow attached

[brightonle]

I am still having an issue where it is giving the same name repeatedly. I am outputting the correct number of rows though. Help would be appreciated!

[binuacs]

@brightonle will check

[brightonle]

@binuacs Great thank you!

[binuacs]

@brightonle updated workflow attached