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!
@brightonle workflow attached
@brightonle will check
@binuacs Great thank you!
@brightonle updated workflow attached