Help for the correct formula

Hi there

I am relatively new to this so any help would be greatly appreciated.


I am analysing a psych experiment


I have an output table/grid with approx 50k rows, as it describes every trial a participant (N=98) performed, there are therefore many rows of the same participant's data.

I also have a table/grid of mean data per participant therefore 98 rows. In this table there is a value which I want to bring over to the first table, that of "high exclusion". I would like this value to be repeated for every row corresponding to that participant's ID.

(I will try to include a picture.)
-Edited to include a sample spreadsheet


There are repeated rows with the same ID in the left table.
I would like to have the High Exclusion values (yellow), corresponding to individual's ID's (orange) copied over from the table on the right to the table on the left.