two columns of data x y, where x repeats and I want unique new set y values in own column

Hi and welcome to the forum!

Can you just be a bit more precise about the actual data set-up you have?

For example, is the number of repetitions of the set of x values constant? I mean, will it always go, e.g.:

10, 11, 12, 10, 11, 12, 10, 11, 12, ...

or could it perhaps vary at some point to:

10, 11, 12, 10, 11, 12, 10, 11, 10, 11, ...?

If it is constant, does it always consist of three entries, as in your example?

Regards

Thanks. And to answer my other question, is it always 3?

Regards

One way...

Data Range

	A	B	C	D	E	F	G	H
1	Item	Values	-----	Item	Values	-----	-----
2	10	302		10	302	100	78
3	11	489		11	489	268	89
4	12	367		12	367	187	99
5	10	100
6	11	268
7	12	187
8	10	78
9	11	89
10	12	99
11

You can use advanced filter to create a list of the unique entries from column A.

Select the data in column A including the column header.
Goto the Data tab
Sort & Filter group>Advanced
Select: Copy to another location
Copy to: $D$1
Select: Unique records only
OK

Then, enter this formula in E2:

=IFERROR(INDEX($B:$B,AGGREGATE(15,6,1/($A$2:$A$10=$D2)*ROW(A$2:A$10),COLUMNS($E2:E2))),"")

Copy down to E4 then across until you get a column full of blanks.