Uploaded August 2021 | Updated November 2026, 2 days ago
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: amzn.to/3tR4AUN
- Buy Office365: 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.
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
Download: https://1drv.ms/x/s!AhCxCSOesgK6hmQ7BoyNxULG6Weu?e=fjiOs0
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
How to Transform Multiple Row Data into A Single Row
youtu.be/ao6ewI2_Tz8
How to Use IF Function in Excel macOS & Windows user
youtu.be/K4W4wFznEWQ
๐งHow to Install Power Query for Excel 2010 & 2013
youtu.be/uZCXgtPIK9Y
๐Transform Your Data from Single Column to Table Structure POWER QUERY
youtu.be/l1mVyuoKMEU
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #TextJoin #DynamicArrays
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: amzn.to/3tR4AUN
- Buy Office365: 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.
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
Download: https://1drv.ms/x/s!AhCxCSOesgK6hmQ7BoyNxULG6Weu?e=fjiOs0
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
How to Transform Multiple Row Data into A Single Row
youtu.be/ao6ewI2_Tz8
How to Use IF Function in Excel macOS & Windows user
youtu.be/K4W4wFznEWQ
๐งHow to Install Power Query for Excel 2010 & 2013
youtu.be/uZCXgtPIK9Y
๐Transform Your Data from Single Column to Table Structure POWER QUERY
youtu.be/l1mVyuoKMEU
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #TextJoin #DynamicArrays





![Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
We will learn how to Un-Stack Data classic way using Excel Online & Excel Mac with two easy Solution
๐ www.ExcelExciting.com
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER : If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding on particular subject for viewers in easy and fun way.
***********************************************************
You can check the following videos as well
Excel Power Query for Office 365 Mac ๐ฅ (Apple) | Phase 1
https://youtu.be/1VRrPPkMGs8
Excel Tip by the Excel Queen ๐ธ๐ป(Faraz & Leila) | https://youtu.be/6CEYKRIlppE
Easiest way to Unhide All Sheets with one line code [VBA MACRO] | https://youtu.be/cs8T8gYltvI
Excel New Version of XLOOKUP & How to use emojis ๐ | https://youtu.be/KAdbfLrpcQ0
XLOOKUP Get the lowest value Column Name in Excel | https://youtu.be/Cbu2ZlvVfXs
***********************************************************
#UnstackData #ExcelOnline #ExcelMac #ExcelTips #FarazExcelMaster #ExcelTrick #MicrosoftCreators #ExcelTips #ProductivityHack #Camtasia #FarazShaikh #ExcelExciting Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution](https://i.ytimg.com/vi/UvrxmOrr8AQ/mqdefault.jpg)
![Today Date in Power Query (Excel & Power BI) - 2 Methods
In this video, we will learn how to get the current date/today date in power query using Excel & Power BI writing little M code
00:00 Intoduction
00:23 Method 01 only for Excel
01:23 Load the date into Power Query Editor Excel
03:19 Method 02 Power Query Excel & Power BI
05:00 End Screen
โฌ๏ธ Download Sample File
https://excelexciting.com/today-date-function-in-power-query-power-bi-excel/
๐ฐ๐ 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 youre helping me keep my blog up and running and youre 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/
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Extract Number & Text from a Cell in Excel | Solution 01 by Power Query
https://youtu.be/GHQXgg2PR_k
How to Refresh Your Excel Power Query for Office 365 Mac ๐ฅ (Apple) | Phase 1
https://youtu.be/1VRrPPkMGs8
***********************************************************
#PowerBI #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForWindows #ExcelTricks #PowerQuery #ExcelPowerQuery #PowerBIPowerQuery Today Date in Power Query (Excel & Power BI) - 2 Methods](https://i.ytimg.com/vi/Uz_uooM7LaE/mqdefault.jpg)


![Convert Number to Words In Microsoft Word [mac & windows]
This video we will learn how to convert number to words in Microsoft Word without writing any VBA code. You can use this Microsoft Word for mac & windows
Formatting Tips
https://excelexciting.com/convert-numbers-to-words-in-microsoft-word-mac-windows/
Convert Numbers To Word In Excel (Spell Number) | Excel VBA
https://youtu.be/eMA39dU3UOE
๐ 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 youre helping me keep my blog up and running and youre 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/
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
https://youtu.be/iei5rMstlJ0
How to Refresh Your Excel Power Query for Office 365 Mac ๐ฅ (Apple) | Phase 1
https://youtu.be/1VRrPPkMGs8
Two Best Excel Tricks by Excel Experts
https://youtu.be/ihVtnUDTCBM
***********************************************************
#Word #FarazShaikh #ExcelExciting #MicrosoftCreators #WordTips #ProductivityHack #MadeWithCamtasia #WordForMac #WordForWindows #WordTricks Convert Number to Words In Microsoft Word [mac & windows]](https://i.ytimg.com/vi/W1Ghyp6Rla0/mqdefault.jpg)
