Combine 2 headers

BRRLL99

Hi Team,

I have following input

i would like merged columns but not rows
both 

Trade -cQuantity

Trade - CollValue

should have merged header as TRADE

BO_	CUST	ISIN	Trade -cQuantity	Trade - CollValue	Document - PhysicalAmount	Document - Settlamount
B_R_A	5B7A	AB123	100	105	110	115
B_R_A	5B7A	AB132	200	180	160	140
B_R_A	5B7A	AB432	300	240	180	120
B_R_A	5B7A	CD455	600	560	520	480
B_R_A	5B7A	DS655	700	450	200	-50

Expected output:

column headers

BO_

CUST

ISIN

Trade

Document

alexnajm

It's definitely possible to do via a Formula tool - create a new field called "Trade" based on your logic. But I am unsure how you want to combine the values in those fields - I'll leave that up to you.

To do a merged cell though in Alteryx is difficult, and I'd say not recommended as you have to dive into the Reporting tools - you could look at something like this to help out: How to Create Merged Cells in Reports, Part 1 - Alteryx Community