How to merge a row with the header in alteryx

[user1850275]

Hi, 

How do you merge row 1 with the header row in alteryx?

[alexnajm]

What is your current data and your expected output?

[user1850275]

I have a header row; the next row is supposed to be a part of the header 

[alexnajm]

I have a presumed way, but I don’t want to guess in case the data is different than what I’m expecting. Can you please provide your current data (or at least a sample) amd your expected output?

[user1850275]

Yeah: here;s a sample

total sales	total sales
in calendar year 2021	in calendar year 2022

the header row should look like:

total sales in calendar year 2021

total sales in calendar year 2022

[alexnajm]

Done!