Need help cross-tabbing half of the table

[AkisM]

My table looks like this:

Name	Date	Type	Value
John	2019-12-01	Height	1.7
John	2019-12-01	Weight	71
John	2019-12-01	Age	23
John	2019-12-01	Sex	M
John	2020-01-01	Height	1.7
John	2020-01-01	Weight	71.3
John	2020-01-01	Age	23
John	2020-01-01	Sex	M

and continues with those 2 variables for each person, which can span across multiple months. Instead, I would like to change this table to change rows only where the name or the month changes, and bring the biometric data in as columns instead. So the above should become

Name	Date	Height	Weight	Age	Sex
John	2019-12-01	1.7	71	23	M
John	2020-01-01	1.7	71.5	23	M
John	2020-02-01	etc	etc	etc	etc
Bob	etc	etc	etc	etc	etc

There isn't always a fixed amount of different months for each person, what matters is the biometric data to change to columns, and rows to be grouped by name + month.

Any ideas would be appreciated

[AkisM · Accepted solution]

Got it, just needed a cross tab tool selecting name and date as "group by values" then change column headers set to "type" and values for new columns set to "value"