Listing all Unique Values from Multiple Tabs in One Tab

rosetc16

New member
Joined
Apr 22, 2017
Messages
43
Reaction score
0
Points
0
Excel Version(s)
Excel 2016
Attached is my desired result and example...

I'm looking to take the unique IDs from each tab and compile them into one desired result tab. As you can see, there are duplicates on each tab and there are some that are on sheet 1 and sheet 2. I only want the IDs to show up once on the desired result tab. Thank you!!
 

Attachments

  • Example.xlsx
    14.3 KB · Views: 13
It would be great if we could also make the information alphabetical when combining them
 
You can achieve your desired result using Power Query
 

Attachments

  • Unique ID's.xlsx
    24.9 KB · Views: 9
Back
Top