How can I do a consolidated flip for repeating data?

[javifais]

Good afternoon,
I have an excel sheet that lists user names in one column and their access level in another column. I would like to flip the data such that the access level becomes a heading and user names become a value below it.
Original data

User A	Access level 1
User B	Access level 2
User A	Access level 2
User B	Access Level 3

Here is what I am trying to get

Access level 1	Access level 2	Access level 3
User A	User A	User B
	User B

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also are you looking for a formula or VBA solution?

 

[javifais]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also are you looking for a formula or VBA solution?

Thank you for your feedback. I have updated my user profile to show office 365, windows and power query. Hopefully, it shows. I am OK with VBA or formula.

 

[Fluff]

Thanks for that.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	User	Access		Access level 1	Access level 2	Access Level 3
2	User A	Access level 1		User A	User A	User B
3	User B	Access level 2			User B
4	User A	Access level 2
5	User B	Access Level 3
6
Data

Cell Formulas
Range	Formula
D1:F1	D1	=TRANSPOSE(UNIQUE(FILTER(B2:B100,B2:B100<>"")))
D2,F2,E2:E3	D2	=SORT(FILTER($A$2:$A$100,$B$2:$B$100=D1))
Dynamic array formulas.

 

[javifais]

This worked great. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.