Concatenate/join two rows

Pav

My data looks like this

Planned	Actual	Variance	Sum	Difference	T
					A
100	100	50	200	0
1		3		4	B
	6		4

The way it looks like this, its because it was a merged cell in excel. What I want to do is to join both of these rows because second row is almost entirely blank and I need both 'T' and 'A' in the same row.

Is there a way to have the data in the same cell in alteryx when uploading merged cells from excel? 

If not, what would be the most suitable way to join these two rows? I've a number of rows below that I don't want to join, it's only the top two rows. 

Thanks

JonA

There's always an easier way, but this dynamically gets to what you want. Creating a list of your columns and concatenating the values of your desired field name was key. Once you deploy the dynamic rename tool, this process becomes a lot easier. 

Concat Rows.yxmd