Transpose the column values into row base on a certain values in a column

[pratheesh]

Hi all,

I have a table that looks like the below "Input" and i want to transpose it into a structure like the "Output"

I need to take the unique values in the column "ID". And print it as once even how many time it appears the column till "country" should print once and the values in the "Rate" column should be print in rows until in available for the same "ID". when the value in the "ID" column changes, it the respected values for the next "ID" should start a print in the next row.

Please see the image for reference.

Thanks in advance

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	ID	City	Country	Rate		ID	City	Country	Rate1	Rate2	Rate3	Rate4
2	1	Rome	Italy	1255		1	Rome	Italy	1255	215	25486
3	1	Rome	Italy	215		2	Paris	France	6558	8142
4	1	Rome	Italy	25486		3	Frankfurt	Germany	9851	31546	51568	1548
5	2	Paris	France	6558		4	Milan	Italy	5994	9666
6	2	Paris	France	8142
7	3	Frankfurt	Germany	9851
8	3	Frankfurt	Germany	31546
9	3	Frankfurt	Germany	51568
10	3	Frankfurt	Germany	1548
11	4	Milan	Italy	5994
12	4	Milan	Italy	9666
13
Test

Cell Formulas
Range	Formula
F2:H5	F2	=UNIQUE(A2:C12)
I2:K2,I5:J5,I4:L4,I3:J3	I2	=TRANSPOSE(FILTER($D$2:$D$12,($B$2:$B$12=G2)))
Dynamic array formulas.