Trying to Flatten a table

[SM66215]

I am trying to flatten this table. I've seen other posts about it, but can't seem to put the pieces together. 

Below is the table that I'm trying to flatten and have it create a new column dynamically for the result date and result 

ID	Result Date	Result
105051	1/20/2024	8
105051	2/13/2024	7.9
105700	9/1/2023	9.4
105700	10/13/2023	8.6
105700	1/12/2024	6.9
106009	11/8/2023	9.9
106009	3/3/2024	8.4
106009	3/4/2024	8.4
106269	10/5/2023	5.7
106269	4/3/2024	6.2
106277	4/11/2024	5.4
106277	4/12/2024	5.4
106370	11/10/2023	10.1
106370	12/5/2023	8.2
106370	3/12/2024	5.9

This is what I want to create, with the dates going in ascending order. 

ID	Result Date	Result	Result Date	Result	Result Date	Result	Result Date	Result
105051	1/20/2024	8	2/13/2024	7.9
105700	9/1/2023	9.4	10/13/2023	8.6	1/12/2024	6.9
106009	11/8/2023	9.9	3/3/2024	8.4	3/4/2024	8.4	10/5/2023	5.7
106269	10/5/2023	5.7	4/3/2024	6.2
106277	4/11/2024	5.4	4/12/2024	5.4
106370	11/10/2023	10.1	12/5/2023	8.2	3/12/2024	5.9

Any insight would be helpful!!

Thanks

[Luke_C · Accepted solution]

Hi @SM66215 

Column names have to be unique, but the workflow would be something like this:

• Transpose
• Number the records within each ID
• Crosstab back out

[SM66215]

@Luke_C 

That is what I needed and thank you so much for your input!!