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 |
Solved! Go to Solution.
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.