merge two headings from input file

[Usamah22]

I have an Excel file which contains two headers (the top one is usually merged) and i need both of them. How can i use this in Alteryx? Can i combine the 2 together so that each month has the top header name in it? 

The brand column at the top is actually merged all the way across but for some reason doesn't show on here.

Group	Brand
QTR ending May-19	Apr-19	May-19	QTR ending Feb-19	QTR ending May-19

[OllieClarke · Accepted solution]

Hi @Usamah22 

Here's a way of doing it:

[OllieClarke · Accepted solution]

If you're cells are merged then you will need the added step of the multi-row formula

[Usamah22]

thanks for this! it works but when i add a select function at the end of this it still shows up with f1, f2 etc as the names. why is that?

Ignore! I just ran it again and it sorted itself out.