Merging two text tables and then merging those rows to remove nulls

[LMJ12066]

Hi all, 

I have used PowerQuery and table.combined two tables, one with Column A, one with Column B. Each of these had 3 rows each, and the aim is to keep it at 3 rows, so I now need to add rows 4-6 of Column B, to rows 1-3 of Column B. 

I've tried using Group By, but it doesn't like it because it is text, and I've tried using conditional columns. Not sure if I'm even close to the right answer. 

Picture below for reference.

I will need to add another two columns and do the same in the future, so any solutions that can work with an extra column or two appreciated. 

Thanks in advance! 

[ryan_mayu · Accepted solution]

@LMJ12066 

you can open a blank query and try this

= Table.FromColumns( Table.ToColumns(Table)&Table.ToColumns(#"Table (2)"))

[LMJ12066]

I hate how easy that was - I knew I was on the right tracks but just couldnt grasp the answer. This is perfect, thanks!

[ryan_mayu]

you are welcome