Cross tab without concatenate

Question

I would like to perform a cross tab on the following data....however I would not like it to be aggregated via the concatenate method. Please see below.

Current Format

Wednesday, Jun 07 -1 #85286074Z00XV63AW225307.033Wednesday, Jun 07 -1#82711164Y000JWY0Q2-111.233Wednesday, Jun 07 -1#75140514YS66JRS2T2-582.993Wednesday, Jun 07 -1 #85286074X00XV5FTN2150003

Desired Format

Wednesday, Jun 07 - #85286074Z00XV63AW25307.03Wednesday, Jun 07 -#82711164Y000JWY0Q-111.23Wednesday, Jun 07 -#75140514YS66JRS2T-582.99Wednesday, Jun 07 -#85286074X00XV5FTN15000

JosephSerpis · Accepted Answer

Hi @IJH34 you need to use a Multi-Row tool to create a new field which you can use to group your data in the crosstab to achieve the desired results. I mocked up a approach however essentially in the Multi-Row I used a field I called Rank which is your data that goes from 1-3 to group your data into a single row in the crosstab tool.