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.
@PWCMN hi, could you please paste the input data in editable format?
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.
@PWCMN Please provide some sample data in excel
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |