Transposing a large dataset

Hello,

Firstly, I couldn't figure out what I call this type of issue so apologies if this is the wrong forum category.
Basically, I have a large amount of data in two columns and I would like to consolidate one of the columns to uniques and then have each value from the second column to be shown across.
I tried putting the data into a pivot table and I was able to see the unique values of my first column but was unable to show all the values (from the second column) attached to that. In the past I have manually transcribed all the values attached to a specific number but it takes me a couple of hours to do it each time and I have to do it for 6 different datasets.

For example:
Transpose issue.png

Is there a quicker way than me manually doing this? Any improvement to what I'm doing now would be greatly appreciated.

Thanks,
04niceck

with Power Query

see attachment

Hi,

with formula Excel365

Formula:

Please Login or Register  to view this content.

Thank you both for the suggestions! Made me finish my analysis in no time

You are welcome

if the problem is solved, hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)

@04niceck

Glad to have helped
Thanks for the feedback