Congregate Data from 1 column

[goble]

Hello,

here is my table :

Name	Day
John	Monday
John	Thursday
John	Saturday
Peter	Tuesday
Peter	Friday

Here is the result I would like :

Name	Day	Day	Day
John	Monday	Thursday	Saturday
Peter	Tuesday	Friday

Thanks for your help !

 

[Kaper]

If by chance you have Excel 365 have a look on simple formula:

=GROUPBY(A1:A6,B1:B6,ARRAYTOTEXT,3,0)

 

[goble]

Hello and thanks, I'm using Office 2021.

This isn't working for me.

 

[Fluff]

I'm using Office 2021.

In that case you may want to update your profile which says 2019.

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Name	Day
2	John	Monday			John	Monday	Thursday	Saturday
3	John	Thursday			Peter	Tuesday	Friday
4	John	Saturday
5	Peter	Tuesday
6	Peter	Friday
7
Sheet6

Cell Formulas
Range	Formula
E2:E3	E2	=UNIQUE(FILTER(A2:A100,A2:A100<>""))
F2:H2,F3:G3	F2	=TRANSPOSE(FILTER($B$2:$B$100,$A$2:$A$100=E2))
Dynamic array formulas.

 

[goble]

Many thanks, perfect !

 

[Fluff]

Glad we could help & thanks for the feedback.