Crosstab multiple specific fields

[jonasebner]

Hello,

i want to crosstab multiple specific fields, which can be dynamic. 

At the moment it looks like this:

place	workers	valid from	day	time
B20	1	2023-01-01	Monday	05:00
B20	1	2023-01-01	Monday2	23:00
B20	1	2023-01-01	Tuesday	06:00
B20	1	2023-01-01	Tuesday2	20:30
...

But i need it this way: 

place	workers	valid from	day	start	end
B20	1	2023-01-01	Monday	05:00	23:00
B20	1	2023-01-01	Tuesday	06:00	20:30
...

I tried it with additional columns but couldnt figure out, how to get the specific fields in the second row the be placed at the right spot. 
Is there a way to do this with alteryx? 

Thanks a lot in advance

[Christina_H · Accepted solution]

This works for your test data

[DataNath · Accepted solution]

Hey @jonasebner, how does something like this look? The Formula tool generates a cleansed weekday for you to group on, as well as creating Start/End flags based on whether it's the 2nd instance of that day (contains 2). Then we use these to group on and employ as our new headers respectively:

[BS_THE_ANALYST · Accepted solution]

@jonasebner One way:

[jonasebner]

works perfect, thank you :) 

[jonasebner]

This works also, thank you