Transpose Data From Same ID Rows To Columns

[Odins_Raven]

Hi, I would like to find a way to put all of the data relating to one ID into one row. Below is a simplified example of the data I have. I have tried to use a pivot table, however it does not take kindly to the text values. What would be the most efficient way to do this, if it is at all possible?

ID	Description
House 1	2 Bed
House 1	1 Bath
House 1	2 Reception
House 2	4 Bed
House 2	2 Bath
House 2	2 Reception
House 3	1 Bed
House 3	1 Bath
House 3	1 Reception

This is what I would like the data to look like:

ID	Bed	Bath	Reception
House 1	2 Bed	1 Bath	2 Reception
House 2	4 Bed	2 Bath	2 Reception
House 3	1 Bed	1 Bath	1 Reception

Any help is appreciated, thanks in advance.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	ID	Description
2	House 1	2 Bed		House 1	2 Bed	1 Bath	2 Reception
3	House 1	1 Bath		House 2	4 Bed	2 Bath	2 Reception
4	House 1	2 Reception		House 3	1 Bed	1 Bath	1 Reception
5	House 2	4 Bed
6	House 2	2 Bath
7	House 2	2 Reception
8	House 3	1 Bed
9	House 3	1 Bath
10	House 3	1 Reception
11
Data

Cell Formulas
Range	Formula
D2:D4	D2	=UNIQUE(FILTER(A2:A100,A2:A100<>""))
E2:G4	E2	=TOROW(FILTER(B2:B100,A2:A100=D2))
Dynamic array formulas.

 

[Odins_Raven]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	ID	Description
2	House 1	2 Bed		House 1	2 Bed	1 Bath	2 Reception
3	House 1	1 Bath		House 2	4 Bed	2 Bath	2 Reception
4	House 1	2 Reception		House 3	1 Bed	1 Bath	1 Reception
5	House 2	4 Bed
6	House 2	2 Bath
7	House 2	2 Reception
8	House 3	1 Bed
9	House 3	1 Bath
10	House 3	1 Reception
11
Data

Cell Formulas
Range	Formula
D2:D4	D2	=UNIQUE(FILTER(A2:A100,A2:A100<>""))
E2:G4	E2	=TOROW(FILTER(B2:B100,A2:A100=D2))
Dynamic array formulas.

Thank you so much, this worked perfectly!

 

[Fluff]

You're welcome & thanks for the feedback.