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 YEARAccount NumberADULT_CHILDCount2021/22123456789C162021/22123456789A254 New Data YEARAccount NumberC A 2021/2212345678916254

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

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

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

Datasets

Transformation

Accepted answers

davidskaife

Hi @Disey

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

Screenshot 2025-06-10 113315.png

Cross Tab.yxmd

All comments

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

Hi @Disey

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

Screenshot 2025-06-10 113315.png

Cross Tab.yxmd

Disey

perfect, many thanks 👍

Disey

Perfect, many thanks 👍

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703