Group and transpose data

[ngenther]

I need data in Column a to be grouped in rows, and the values for "Answer" to be associated horizontally in the row with the earliest rating by date on the left. I attached some of the file.

thank you very much.

[KOKOSEK]

Like this:

	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	client_id	1040	1083	1089	1145	1170	1192	1235	1244	1267	1308	1311	1330	1339	1361	0
2	21/02/2020	0	0	0	0	0	0	0	0	0	0	0	34	0	0	0
3	21/02/2020	0	0	0	0	0	0	0	0	20	0	0	0	0	0	0
4	25/02/2020	0	0	0	0	0	0	0	0	0	0	27	0	0	0	0
5	26/02/2020	0	20	0	0	0	0	0	0	0	0	0	0	0	0	0
6	02/03/2020	0	0	0	0	0	0	0	0	0	0	0	28	0	0	0
7	04/03/2020	0	20	0	0	0	0	0	0	0	0	0	0	0	0	0
8	05/03/2020	0	0	0	0	0	0	0	0	0	0	30	0	0	0	0
9	06/03/2020	0	0	0	0	0	31	0	0	0	0	0	0	0	0	0
10	09/03/2020	0	0	0	0	0	0	0	0	0	0	31	0	0	0	0
11	11/03/2020	0	0	0	14	0	0	0	0	0	0	0	0	0	0	0
12	13/03/2020	0	0	0	0	0	0	20	0	0	0	0	0	0	0	0
13	13/03/2020	0	0	0	0	0	0	0	0	0	0	0	30	0	0	0
14	13/03/2020	0	0	0	0	0	0	0	0	0	0	32	0	0	0	0
37	12/05/2020	0	0	0	0	0	0	0	0	0	0	0	0	0	19	0

Sheet: ORS Ancestor ID with Rating

check attached file.

[alansidman]

A pivot table as shown in the attached?

[ngenther]

Thank you!

[ngenther]

Wonderful! I did a pivot but didn't try "Sum" to get the actual value. thank you!