Data Transformation

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

rowid.xlsx

Preparation

Accepted answers

ShankerV

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

Data Transformation.yxmd

rowid.xlsx

PanPP

Hi @razzy

I have uploaded a sample WF.

Hope this helps.

Sample WF - Fill in ID.yxmd

All comments

ShankerV

Hi @razzy

Please use Multirow formula to achieve the result.

ShankerV

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!!!!