In this video, we will learn how to transform multiple row data into a single row with a simple formula TEXTJOIN trick will help us to combine the values in one cell in Excel for Mac and the same can be used for Excel for Windows. Combine or merge cell values in one cell was not so easy. But this trick can seal the deal to combine or concatenate values in one cell without any complex formulas.

00:00 Introduction
00:30 Making the data ready to combine
01:23 Extract Unique Records with UNIQUE Function
01:50 Paste unique value with Advance filter
02:15 Building the Solution
06:00 End Screen

Affiliate links :
Support me with your Amazon purchases: https://amzn.to/3tR4AUN
Buy Office365: https://bit.ly/3nKcbnk

Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family ‍‍‍ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.

https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/

Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudiarabiam...

Download: https://1drv.ms/x/s!AhCxCSOesgK6hmQ7B...

Like Facebook Page :
  / excelexciting  

Join The Facebook Group
  / excelexciting  
***********************************************************
You can check the following videos as well

How to Transform Multiple Row Data into A Single Row
   • How to Transform Multiple Row Data in...  

How to Use IF Function in Excel macOS & Windows user
   • How To Use IF Function In Excel macOS...  

How to Install Power Query for Excel 2010 & 2013
   • How To Install Power Query For Excel ...  

Transform Your Data from Single Column to Table Structure POWER QUERY
   • Transform Your Data from Single Colum...  

***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #TextJoin #DynamicArrays