Transpose? Cross Tab? Not sure.

[bsolove123]

I want to transform my data so that each instance of effective data is in a new field. I've attached test data below.

Start:

Rule Type	Jurisdiction Type	State	Date Rule	Effective Date
Default	State	Kansas	Beginning	01/01/2021
Default	State	Kansas	Beginning	01/01/2020
Default	State	Alaska	Beginning	01/01/2020
Default	State	Alabama	Beginning	01/01/2021
Default	State	Alabama	Beginning	01/01/2020

End: 

Rule Type	Jurisdiction Type	State	Date Rule	Effective Date 1	Effective Date 2
Default	State	Kansas	Beginning	01/01/2020	01/01/2021
Default	State	Alaska	Beginning	01/01/2020
Default	State	Alabama	Beginning	01/01/2020	01/01/2021

[binuacs]

@bsolove123 This can be achieved using the summarize tool. please see the workflow below 

[Qiu]

@bsolove123 
I usually consider this, use Cross Tab for vertical to horizontal, Transpose for Horizontal to Vertical.

[JarekSkudrzyk]

@bsolove123 @Qiu 

just added sort tool to @Qiu 's solution to show earlier dates first (will work ok in this case and other cases where the date is in Date format)

[binuacs]

@bsolove123  I thought of add another way of doing this - using Multi-Row formula