Combined Columns (2 into 1)

[JohnBooj]

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]

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

[JohnBooj]

Hi Luke - 

Attached is the file I am working with. 

Thanks!

John

[Luke_C]

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.