Combined Columns (2 into 1)

Question

Hi -

I am trying to figure out to combined two columns into one. I would like to combined quarters 1 and 2 into one column and combined quarters 2 and 3 into a column and than add another column with a total column.

Basically 3 columns for each company:

Total Q1 & 2 || Total Q3 & 4 || Total (Full Year)

Any help would be greatly greatly appreciated!

thanks!

John

Luke_C · Answer

Hi @JohnBooj

Something like this should do the trick. If you don't need accounts just uncheck it in the grouping of the last crosstab tool.

When trying to transpose multiple header rows you need to separate them out and process them separately, then join back based on the column positioning.

New Workflow2.yxmd

JohnBooj · Answer

Hi Luke -

Attached is the file I am working with.

Thanks!

John

Alteryx.xlsx

Luke_C · Answer

Hi @JohnBooj

Attaching data would be helpful rather than a screenshot, happy to help but not keen to re-type all of that.

Where do the accounts come into play? Should the total be kept at the account level or summed up? In other words, should the output be: Company | Account | Q1/Q2 | Q3/Q4 | Total or Company | Q1/Q2 | Q3/Q4 | Total