Transpose based on contents of row?

[szemken]

Hello !

I aim to transpose the input format table in the attachment to the output format (See screenshot). I am unsure on how to use the 'Action' field as a basis to get the correct timestamps into the correct column. Does anyone have an idea how to transpose this data conditionally?

If Action = En Route, place timestamp into En Route Column,

Else if Action = On Site, place timestamp into On Site Column,

Else if Action = WO Complete, place timestamp into WO Complete Column

Any ideas?

Thank you !

[michelle_mathews · Accepted solution]

Hi @szemken , in this case you'd want to use the Crosstab tool and configure like below: 

[binu_acs · Accepted solution]

@szemken Similar solution to @michelle_mathews