Create one row from two rows of data with new column headers

[Disey]

Please see following example of what I have and what I want to create so that all my data for the two counts are all on one row, thank you

YEAR	Account Number	ADULT_CHILD	Count
2021/22	123456789	C	16
2021/22	123456789	A	254
New Data
YEAR	Account Number	C	A
2021/22	123456789	16	254

[abacon]

@Disey  Use a cross tab tool, group on Year and Account number, make Adult_Child the header and count the value field. This will do what you’re looking for.

Bacon

[davidskaife · Accepted solution]

Hi @Disey 

A Cross Tab tool configured like below appears to do the trick:

[Disey]

perfect, many thanks 👍

[Disey]

Perfect, many thanks 👍