Merge Columns with a Separating Delimiter [2 Examples]

There are times when you'd want to combine the values in different columns to form a new column (with it's own header/title). There are actually a couple of ways to do this and it's quiet easy. This video will show two examples of how it's done. One with a function and the other with Power Query.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[NyashaHill]

This video literally just saved me HOURS of work. Thanks so much!!!

[ramaba]

you solve my pb in 5 sec while I was thinking for 5 mins. thanks

[isikcelaal]

you saved me bigtime with the last one thank you

[Wildbill]

I usually use the ampersand, the third example mine cant do, atleast i dont think so, must be in the settings,
I use wps kingsoft, it has all the funtions, but, when examples are given to get to certain commands through the settings, i cant find it,

I use the mobile version....

Thanks though, you have given me some grest ideas...