Data Transformation

[razzy]

Hi all, i would like with transforming the dataset attached on the workbook here. My desired output should be if to fill the same ID in the ID column when the Record Id is the same. For instance ID :NIHUP3

should be all in ID column for record ID=1 etc etc.

Thanks all. Happy Holiday

[ShankerV]

Hi @razzy 

Please use Multirow formula to achieve the result.

[ShankerV · Accepted solution]

Hi @razzy 

Please find the desired output:

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[PanPP · Accepted solution]

Hi @razzy 

I have uploaded a sample WF.

Hope this helps.

[razzy]

Thank you so much

[razzy]

This works better too