How to crosstab multiple fields?

[arthurmauk]

Hi there, I currently have a table that looks like this:

DA_DateTime	DA_Payload	DA_Field Numbers
19/06/2020 15:29	Process starting for ticket: ACM-155	1
19/06/2020 15:29	User: 'afurnish', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'afurnish'	2
19/06/2020 15:29	Andy Furnish has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly	3
19/06/2020 15:29	Ticket ACM-155 has been resolved with the comment 'Access Granted'	4
22/06/2020 09:02	Process starting for ticket: ACM-163	1
22/06/2020 09:02	User: 'vbernik', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'ohalberthal'	2
22/06/2020 09:03	Volha Bernik has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly	3
22/06/2020 09:03	Ticket ACM-163 has been resolved with the comment 'Access Granted'	4

And I would like to crosstab it into something that looks like this:

1	1_DateTime	2	2_DateTime	3	3_DateTime	4	4_DateTime
Process starting for ticket: ACM-155	19/06/2020 15:29	User: 'afurnish', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'afurnish'	19/06/2020 15:29	Andy Furnish has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly	19/06/2020 15:29	Ticket ACM-155 has been resolved with the comment 'Access Granted'	19/06/2020 15:29
Process starting for ticket: ACM-163	22/06/2020 09:02	User: 'vbernik', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'ohalberthal'	22/06/2020 09:02	Volha Bernik has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly	22/06/2020 09:03	Ticket ACM-163 has been resolved with the comment 'Access Granted'	22/06/2020 09:03

How would I use the crosstab tool to do this please? Thanks in advance! 🙂 

[atcodedog05 · Accepted solution]

Hi @arthurmauk 

Here is how you can do it.

Workflow:

Hope this helps : )