Transpose and field transformation

[victorholving]

Hello everyone,

I'm having a difficult time solving a very specific issue using Alteryx Designer.

I hope that someone within this community will be able to help out! 

The situation is (luckily) rather easy to explain

I currently have a data input from Excel that looks like this:

F1	Monday	Tuesday	Wednesday	Thursday	Friday
Start time	08:30	08:00	08:00	08:15	08:00
End time	16:00	15:30	15:30	15:45	15:30
Hours	07:30	07:30	07:30	07:30	07:30
Ordinary time	360	355	370	365	340
Personal time	55	60	45	50	75
Task shifts	15	10	12	11	10

I need make a workflow that will make data look like this:

Day	Start time	End time	Hours	Ordinary time	Personal time	Task shifts
Monday	08:30	16:30	07:30	360	55	15
Tuesday	08:00	15:30	07:30	355	60	10
Wednesday	08:00	15:30	07:30	370	45	12
Thursday	08:15	15:45	07:30	365	50	11
Friday	08:00	15:30	07:30	340	75	10

Any suggestion on how to perform this transformation within alteryx would be greatly appreciated. 

Best regards,

Victor

[LordNeilLord · Accepted solution]

Hey @victorholving

A transpose followed by a crosstab should do the trick....it messes with the sort order but that should be easy to fix :)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[victorholving]

It worked - Incredible! Thanks a lot :-)