Adding more rows to column field names

Mwatts23

Hi,

I would like to seek your help regarding adding more rows in the column field names.

I was exploring the Cross Tab tool but it is not working for me in stacking 3 fields as column names.

Below is the screenshot of the sample data and the expected output. I also attached the xlsx file for reference.

Please let me know if you have any clarifications on my query. Thank you.

Best regards,

Michael

Additional More Row to Column Field Names_Test.xlsx

Workflow

Tips and Tricks

Best Practices

Accepted answers

bkurt

Hi @Mwatts23 ,

You're welcome. I added a version below that gives the values as you require.

If it is what you want, I would be very happy if you gave me my first solution badge .

Best regards,

Bora

More rows (1).yxmd

binu_acs

@Mwatts23 One way of doing this

Cross_Tab_1021.yxmd

All comments

bkurt

You can either concatenate the string values or you can create rows and add them with a join tool. I think the file in the attachment should help you out.

More rows.yxmd

Mwatts23

Hi @bkurt ,

Thank you so much for the quick response. Is it possible to add the "Year" next to the Account ID? Like the one in my desired output on top.

Best regards,

Michael

bkurt

Hi @Mwatts23 ,

You're welcome. I added a version below that gives the values as you require.

If it is what you want, I would be very happy if you gave me my first solution badge .

Best regards,

Bora

More rows (1).yxmd

binu_acs

@Mwatts23 One way of doing this

Cross_Tab_1021.yxmd

Mwatts23

Thank you @binu_acs for sharing your workflow. This is very useful as well.

Best regards,

Michael

Mwatts23

Hi @binu_acs,

From your workflow, Is it possible for the country, region and metro not to keep on duplicating on the final output? because I have 11k+ account ids on my data and it gives me 11k+ column names as well.

Best regards,

Michael

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335