How to compare data with a column that is not constant

[KevinMac]

Hi there,

I am looking for a solution that would help compare 2 data sets but the columns are not always the same.

Below is an example I just made up for possible data that I would need compared:

First data set:

Name	Title	1	2	3
Dave	Designer	balloon	chips	bag
John	Manager	bottle	cup	headphones
Chris	Architect	shoes	tie	rabbit

Second data set:

Name	Title	1	2	3
Dave	Designer	chips	bag
Dennis	Manager	bottle	cup	headphones
Chris	Architect	shoes	rabbit

The issue is that there is no primary key to match the rows to and any element can change from before the numbered columns. Also if an element from the 1-2-3 section is removed it is shifted a column down.

Is there a way to know which rows are related to each other based on the remaining information left on each row? 

[RishiK]

@KevinMac 

Have a play with the Transpose tool.  You don't need to specify a key / group of columns if you don't know it.

The Transpose will flip the data in a Name (column) - Value (the actual data) format, which may make it easy to compare in a dynamic way.

[JosephSerpis · Accepted solution]

Hi @KevinMac I mocked up a workflow that should help in your comparison. Let me know what you think?