2 EASY Ways To Combine Multiple Columns Into One | TEXTJOIN & PowerQuery | Office 365
👇 LET'S CONNECT 👇
https://linktr.ee/excelupnorth
—————————————————————
⏰ Timestamps ⏰
00:00 Intro
00:19 Example Data Overview
01:14 Using TEXTJOIN
03:38 Using PowerQuery
06:24 Wrap-up
—————————————————————
In this video, we'll be exploring a common Excel task together: efficiently combining data from multiple columns into one. This walkthrough covers practical methods for merging columns, avoiding manual work and complicated formulas. We'll be using a powerful Excel function, to streamline the process. By the end, we'll have a clear understanding of how to transform messy spreadsheets into clean, organized data in just a few steps.
Starting with an employee shift schedule, we'll look at combining first and last names into a single column using functions like CONCATENATE, CONCAT, and TEXTJOIN. For those with access to the TEXTJOIN function, it simplifies the process. But for anyone using older versions of Excel, CONCAT and CONCATENATE will get the job done just as well.
Finally, we'll use Power Query, where columns from an imported dataset can be combined effortlessly using the Merge Columns command. It's a powerful feature that doesn’t require writing code, making data transformation even more accessible. We’ll also draw comparisons between Power Query’s Text.Combine function and Excel’s TEXTJOIN, highlighting the handy way Power Query skips over empty values automatically. Whether working with shift schedules or large datasets, these techniques will streamline data management tasks for anyone tackling complex spreadsheets.