Based on Red Column, you have to create dynamic Blue Header Columns in Alteryx.

[faisal9999]

Can anyone solve this I have date column and I want the output in the attached image.

06:12P
08:12A
12:38P
10:42A
12:12A

[ChrisTX · Accepted solution]

Which data types do you want for the output?

Check out the DateTime functions:  DateTime Functions (alteryx.com)

DateTimeFormat

DateTimeParse

DateTimeAdd

Chris

[Raj · Accepted solution]

@faisal9999 
find the solution attached
mark done if solved.

[faisal9999]

.