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 !
Solved! Go to Solution.