Combine 2 headers in 1 table

Question

Hi everyone,

I have a reporting table like this

I also have Sell time of these products (which is 15 months previous report time)

My desire output is to combine these time into 1 table, and it will be like this:

How can I do this in Alteryx? Thank you so much!!

anhnguyenngoc2002 · Answer

Thank you so much !!

ahsanaali · Answer

See if this works.

2023-05-14_Combine 2 headers in one table.yxmd

geraldo · Answer

@anhnguyenngoc2002

It is not clear what you want. Here's a step on how to join 2 headers. It will need some adjustments for them to be aligned and with the columns with the same sizes. but it is the first idea. I hope it's the beginning way.

Maybe Combine2 is what you're looking to start with.

Combine.yxmd

Combine2.yxmd