Need some help with a transpose

[ej3225]

Hey folks, 

I am having a bit of trouble figuring out a transpose/pivot of data from a report I am receiving. 

Currently the report I get is like the following sample table:

Name	Volume	Miles
John
2021-03-01	200	40
Lisa
2021-03-01	150	25
Pam
2021-03-01	310	18
John
2021-03-02	250	50
Lisa
2021-03-02	200	45
Pam
2021-03-02	290	30

And I would like to have the following output: 

Date	Name	Volume	Miles
2021-03-01	John	200	40
2021-03-01	Lisa	150	25
2021-03-01	Pam	310	18
2021-03-02	John	250	50
2021-03-02	Lisa	200	45
2021-03-02	Pam	290	30

Any help on this would be greatly appreciated as I have been noodling on this for the past couple of days. 

[Emil_Kos · Accepted solution]

Hi @ej3225,

A combination of filter tool + join tool will do a trick:

Just remember that in the join tool you need to join the records by position:

Output:

[ej3225 · Accepted solution]

This worked perfectly! completely forgot I could join by position.