Cross tab without concatenate

[IJH34]

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
#85286074Z00XV63AW	2
25307.03	3
Wednesday, Jun 07 -	1
#82711164Y000JWY0Q	2
-111.23	3
Wednesday, Jun 07 -	1
#75140514YS66JRS2T	2
-582.99	3
Wednesday, Jun 07 -	1
#85286074X00XV5FTN	2
15000	3

Desired Format

Wednesday, Jun 07 -	#85286074Z00XV63AW	25307.03
Wednesday, Jun 07 -	#82711164Y000JWY0Q	-111.23
Wednesday, Jun 07 -	#75140514YS66JRS2T	-582.99
Wednesday, Jun 07 -	#85286074X00XV5FTN	15000

[JosephSerpis · Accepted solution]

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.

 

 

[nagakavyasri]