Combining/merging/standardizing 3 datasets/lists while maintaining row data

Please & thanks in advance!

I have 3 worksheets that each have a different list in the first column. The lists are several hundred cells long with data filling the the correspondng row.

list troubleshooting.png I have created a master list by filtering the number of occurences. Now I would like to maintain the data in the rows while shifting them to match the masterlist.


See the attachment labled 'list troubleshooting' to see an example of the master list with two other lists that I would like to match the master while still maintaining the data contained in their rows.

Thanks again!

EcoPete
"Judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid" Albert Einstein