Combining data from 3 different data sets with common ID's onto a summary sheet in specific places

[RichD2020]

hello, I have 3 sets of data, they each have 2 columns, one with an ID number and the other has a score in it. I want to be able to be able to pull the scores from each data set that relate to an ID (some ID numbers may only have 1 or 2 scores) onto a separate worksheet or the same one if easier. How do I do this?

[#2]

@RichD2020 

Assuming this is just a one-time thing, I'm going to give you a less than elegant solution. I'm sure there are Power Query methods, but my sense is that you're more or less a beginner with Excel and so Power Query may be a step too far.

This involves

1. just copying all the IDs into a singe column.

2. using the UNIQUE function (new to Excel so you do need the most current version of Excel) to get just a single instance of each ID

3. unnecessary, but I used SORT with UNIQUE to sort the IDs into order

4. Use VLOOKUP to get the scores from each data set.

As I said, it's not the most elegant--Power Query would be that--but it'll work. I used your example data in the attached.