Best way to identify unique rows of data

[ab11viva]

I have 2 large spreadsheets of data with ~40 columns each. (essentially a before/after look at data)  The columns are identically named/positioned.  I'd like to create a workflow that compares all data for a given row in spreadsheet 1 with spreadsheet 2.  The rows in each spreadsheet may not be the same. (i.e. row 5 in spreadsheet 1 might actually match row 7 in spreadsheet 2).

I thought I'd be able to do this relatively easily but I'm a bit of a novice and this is proving more difficult than I thought.  I'm hoping that this is easy as I think it is but would appreciate any guidance you can provide.

Thanks

[Alekh]

You can unions the inputs and use the unique tool if the amount of columns are going to be the same and won't change (as it isn't dynamic).

You can transpose (which is dynamic) and then group them together again using the Summarize tool and then use the unique tool to make it dynamic. 

I've attached a workflow for both.

[ChrisTX · Accepted solution]

Here's a related post from earlier this week:

Excel files comparison

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-files-comparison/m-p/442848#M844...