How do I merge files and not duplicate products

[Chad_Cox]

I have 3 data files in this example.  The actual data files will grow over time.  I want to merge them so each unique item and size only appear once, and then for each occurrence its price is shown in a new column.

End results would look like this:

Where there is no value in one of the last three columns this represents that the item was not in stock and therefore not in the input file for that date.

[MilindG]

Check out the workflow. See if that works

[Chad_Cox]

Close, I swapped out the Unique step for a Sort to show matches.  In the final output, the desire is to have each unique combination of the first 3 columns appear once and then the values would appear out to the right.  The image below shows two highlighted areas.

[MilindG]

[binuacs · Accepted solution]

@Chad_Cox One way of doing this