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

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. 

ccoakley.yxmd