5 Ways to Combine Columns in Excel (#3 Is Foolproof)
In this video I'll show you five ways to combine columns in Excel.
I'll start with simple methods, such as using the & operator or using the CONCAT function, and then move on to slightly advanced concepts like the text join function, Flash Fill, and Power Query
All these methods have their pros and cons, which I will explain in the video.
00:00 Intro
00:24 Using & and CONCAT
02:22 Using TEXTJOIN
06:16 Using Flash Fill
07:28 Using Power Query
📂 Download File: https://www.dropbox.com/scl/fi/c1lzcr...
Read the Article: https://trumpexcel.com/combine-two-co...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://trumpexcel.com/excel-vba-course/
✅ Free Power Query Course - https://trumpexcel.com/power-query-co...
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial #SumitBansal