Converting multiple rows into one row different columns in Excel-CodePudding

I am down to any help with converting multiple rows into multiple columns in Excel. I need to change table like this:

this .

Into something like this:

this .

I've tried coding it in VBA, because transpose function does not work exactly like this, but I don't know how to loop it with detecting code from left column 1st table. I've read something about doing similar things in T-SQL but I have no clue how to code in this language. I'm up to any ideas about function I should use or anything. Btw. I need it for many ID's not only short table like in example.

CodePudding user response：

This can be accomplished using a

First put the formula in D1 to extract all the unique Ids from Column A. =UNIQUE(A1:A9).

Then use these values as the input to create the other columns, by using the formula in cell E1 as =TRANSPOSE(FILTER(B1:B9,A1:A9=D1)), and filling the formula down.