Adding New Column with specific naming

[PWCMN]

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.

[JarekSkudrzyk]

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

[JarekSkudrzyk]

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.

[binu_acs]

@PWCMN Please provide some sample data in excel