Merging Columns into one continuous column

[Jambo_]

Hi,

I've recently been using power query to manipulate imported email lists. One thing I am struggling with is merging the columns into one continuous one.

At the moment it looks something like this. I have merged seperate queries together but I want them to be listed all within the 1st column.

I have tried adding custom columns and using formulas but just can't get it right.

 

[Legacy 143009]

Try "Append Queries" option instead of "Merge Queries"

 

[bferraz]

Hey,

Can you try following these steps?

Add Column -> Merge Columns -> Tab

Result:

You can later remove other columns

 

[Jambo_]

Try "Append Queries" option instead of "Merge Queries"

View attachment 81024

Perfect thank you. Glad that was an easy one!

 

[Legacy 143009]

Thanks for the feedback

 

[jdellasala]

From the pictures you posted, it looks like there are never values in the same row for multiple columns. Have you tried just using Merge Columns on the Transform tab?