Moving data for a record from multiple rows to a single row

[JMoriarty65]

I have a set of data that has a semi repetitive format that i would like to move from having multiple rows per record to a single row, but i always struggle with transpose and crosstab. Not sure if this can be done, any help would be appreciated.

This is the current format

Evaluation Date	Evaluation Score
12/8/2023 8:46	100
Contract Number	571789878
12/19/2023 13:53	100
Contract Number	500005404
12/19/2023 14:37	0
Contract Number	571078974
Was the transaction processed accurately	taxes were withheld for state of NC. No taxes should have been withheld
Was the transaction processed accurately errors	taxes should not be withheld for a 1035 exchange.

This is the format i would like 

Evaluation Date	Evaluation Score	Contract Number	Was the transaction processed accurately	Was the transaction processed accurately errors
12/8/2023 8:46	100	571789878
12/19/2023 13:53	100	500005404
12/19/2023 14:37	0	571078974	taxes were withheld for state of NC. No taxes should have been withheld	taxes should not be withheld for a 1035 exchange.

[Luke_C · Accepted solution]

Hi @JMoriarty65 

Here's one way:

1. Assign an ID to each record, I did this by looking for the date format in the first column.
2. Separate the data between the evaluation date/score and the other 3 fields
3. Cross tab the other 3 fields and join back

[JMoriarty65]

Thanks for the help!