Adding New Column with specific naming

Question

I would like to add a new blank column every time there is a change in ParentMultID, which is a total of 4 new columns. Once they are created I need the Jurisdiction ID and OrgID from the specific ParentMultID to be added respectively. The DatasetName should equal the ParentMultID and the MultID should be a concatenate from the ParentMultID-OrgID. Please see pictures below to see the final result.

Capture.PNG

Capture 1.PNG

binu_acs · Answer

@PWCMN Please provide some sample data in excel

JarekSkudrzyk · Answer

you can use multi-row formula to "catch" the records where ParentMultID changes (Row-1 ParentMultID != Row 0 ParentMultID).
Then you can create new columns with the logic you described using formula tools.

JarekSkudrzyk · Answer

@PWCMN hi, could you please paste the input data in editable format?