Combining Record Number with Dates and Scores

[ccoakley]

Hi everyone,

I am having trouble combining record numbers into one line with new column headers.

This is the current data I have:

Record Number	Score	Date
1	100	12/1/2022
1	90	1/5/2023
2	10	1/2/2023
2	15	1/3/2023
2	85	6/2/2024

This is the end product I am looking for:

Record Number	Score #1	Date #1	Score #2	Date #2	Score #3	Date #3
1	100	12/1/2022	90	1/5/2023
2	10	1/2/2023	15	1/3/2023	85	6/2/2024

Any help or guidance would be greatly appreciated.

Thank you!

[AGilbert · Accepted solution]

Attached workflow is an example of using the Tile tool to allow the Transpose/CrossTab tools to position the data. The fork is to show how the CrossTab likes to sort columns which often times is not how you want them. 

Hope this is helpful. 

[Raj]

@ccoakley another way of doing this
hope this helps
please close this if solved or let us know in case you are looking for something else.

[ccoakley]

This worked, thank you!