Unstacking data into multiple coloumns based on adjacent index value

Hi there!

First time user of this forum and hoping that someone out there can help me to a simple solution to what appears to be on the face of it an easy problem to solve.
I've attempted using the power query, pivot tables and INDEX, MATCH functions to get Excel to carry out what I need but I think my lack of understanding is holding me back.

In essence I have a data set in 2 columns. The first columns is an index number and the second columns is my data. I'd like to display my data grouped into distinct columns based on the adjacent index value.

That's it!

I've attached a spreadsheet showing an example of the data and how I would like it displayed manually. Any help is really appreciated

Thanks in advance!

F4=IFERROR(INDEX($C$4:$C$38,AGGREGATE(15,6,ROW($C$4:$C$38)-ROW($C$4)+1/($B$4:$B$38=F$3),ROWS($C$4:C4))),"")

Copy across and down

Or

Formula:

Please Login or Register  to view this content.

HI,

Thanks for the solution!