Converting Columns to Rows for Reconciliation

I'm trying to get the data I have into a single row based on record ID

So one row for all the information with a record of 1 and another with all of the information for a record of 2 etc...

The important piece, is that I want them all on the same row for each record and to say if they are the same or different

everytime I try to go from the columns above to below it does not work! Keep in mind there is about 150 different columns and 5000 records so to do it manually is very time consuming! Any help would be greatly appreciated!

Transformation

Accepted answers

messi007

@AdrianAlt,

Please take a look into the workflow below:

I created the reconciliation check and modified the row below in order to check

Attached the workflow,

Hope this helps!

Regards

Compare_20210319.yxmd

All comments

messi007

@AdrianAlt,

Could you share a sample data.

It will help us to provide the expected solution.

Regards,

AdrianAlt

@messi007,

Please find a sample dataset, hope this is enough, sheet one is the current format and sheet 2 is the desired! Thank you!

Example.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703