Uploaded March 2022 | Updated November 2026, 5 days ago
In this video, we will learn how to Stack Data In Excel Using Dynamic Arrays (Excel for Mac & Windows), with a few simple steps and your data is stacked in Excel
โฑ Time Stamp
00:00 Intro
00:39 Understanding the logic
01:30 Number Of Columns/Rows Stack Data
02:08 Generate Group Sequence with mod function for Columns
03:44 Generate Group Sequence for Rows
05:00 Wrapping all formulas into Index Function
06:55 End
--------------------------------------------------------------
๐ 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
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
I Automated ๐ค my Meetup Event with Power Automate Desktop & Excel
youtu.be/u5hZ7XxZyhU
How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)
youtu.be/H62E173CzBo
Sort Problem With Numbers As Text SOLVED โ (Excel for mac & windows)
youtu.be/7phGPaZ89DQ
How to Calculate Hijri Age In Excel (mac & windows)
youtu.be/Cs0MgpppuPA
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #StackData
In this video, we will learn how to Stack Data In Excel Using Dynamic Arrays (Excel for Mac & Windows), with a few simple steps and your data is stacked in Excel
โฑ Time Stamp
00:00 Intro
00:39 Understanding the logic
01:30 Number Of Columns/Rows Stack Data
02:08 Generate Group Sequence with mod function for Columns
03:44 Generate Group Sequence for Rows
05:00 Wrapping all formulas into Index Function
06:55 End
--------------------------------------------------------------
๐ 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
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
I Automated ๐ค my Meetup Event with Power Automate Desktop & Excel
youtu.be/u5hZ7XxZyhU
How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)
youtu.be/H62E173CzBo
Sort Problem With Numbers As Text SOLVED โ (Excel for mac & windows)
youtu.be/7phGPaZ89DQ
How to Calculate Hijri Age In Excel (mac & windows)
youtu.be/Cs0MgpppuPA
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #StackData



![Combine Sheet Into One Master Sheet With VBA [Excel for Mac & Windows]
In this video, we will understand the logic on how to combine sheet code works in Excel For Mac & Windows.
๐ 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.
Grab the VBA code here
https://excelexciting.com/combine-active-workbook-all-sheets-into-one-master-sheet-with-vba/
๐๐Combine Multiple Excel Worksheets Into One Worksheet | Power Query
https://youtu.be/F5fjv6nXvZo
๐ 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: 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
Learn In 3 Minutesโฐ How To View Two Sheets Side By Side In Excel
https://youtu.be/dvhqseTo_HQ
How To VLOOKUP & Handle VLOOKUP Error #NA In Excel
https://youtu.be/ugg-NCNscUI
๐ฎExcel Trick : How to Sum the Number With Spaces Or Special Characters
https://youtu.be/dgUu24eUzWw
๐ฎConvert Numbers To Word In Excel (Spell Number) | VBA
https://youtu.be/eMA39dU3UOE
***********************************************************
#FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Combine Sheet Into One Master Sheet With VBA [Excel for Mac & Windows]](https://i.ytimg.com/vi/sIxZP3aRyU8/mqdefault.jpg)

![Excel Trick# 3- Convert Numbers to Percentage [Part 01] - #Shorts #exceltips #excel #exceltricks
In this video, we will learn how to convert numbers to percentage values in Microsoft Excel
โฑ Time Stamp
00:00 Intro
๐ 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/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Excel Trick# 3- Convert Numbers to Percentage [Part 01] - #Shorts #exceltips #excel #exceltricks](https://i.ytimg.com/vi/t3CbpkB1Frc/mqdefault.jpg)
![How and when to use LAMBDA Function in Excel for Mac & Windows
In this video we will learn how to us the BRAND-NEW LAMBDA function in Excel for the beginners and advance users. Simple tricks explain this video how LAMBDA work in Microsoft Excel for mac and you use the same way for windows
00:00 Introduction
00:22 About the LAMBDA Function
01:24 LAMBDA Syntax
01:40 LAMBDA Example 01
03:28 How paste LAMBDA in name manager
05:04 LAMBDA Example 02
08:14 Advantages using LAMBDA in Excel
08:35 How to share the LAMBDA in Excel
09:22 Can it be reference to another workbook?
09:37 End Screen
Spell Number (VBA UDF Function)
https://excelexciting.com/convert-numbers-to-word-in-excel-spell-number/
Download LAMBDA Example file
[WebsiteLink]
๐ 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 to queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page:
https://www.facebook.com/ExcelExciting/
๐ฅJoin the Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Extract Multiple Matching Records
https://youtu.be/pTVxxaZQx24
Excel with 41Million+ Records & still why UK have Data Loss of COVID-19 Cases ?
https://youtu.be/YVMTgZsRCGQ
Learn how to use Microsoft Flow / Power Automate
https://youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
https://youtu.be/xfIPFiAxQcQ
Create Organizational & Business Flowcharts Linked to Excel
https://youtu.be/Cor1mixgotY
***********************************************************
#LAMBDA #excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks How and when to use LAMBDA Function in Excel for Mac & Windows](https://i.ytimg.com/vi/tEzeQfdXZII/mqdefault.jpg)


![Save Email Attachments from Outlook To OneDrive - Power Automate
In this video we will learn how to save email attachments from Outlook Personal account to OneDrive personal. This can also be applicable for work or school account but need to select the correct connector to make sure it works. There are many VBA complex code that can save the email attachments, this is Modern and easy solution with Microsoft Power Automate.
00:00 Intro
00:20 How to Login to Power Automate (formally Microsoft Flow)
00:50 Checking the template galley
01:40 Create Automated Cloud Flow from scratch
05:15 Test the flow
06:55 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 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/
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅ Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Make Cross functional Charts in Excel with Data Visualizer for VISIO
https://youtu.be/1rZWtY_e9D4
Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
๐ฎExcel Trick: Find Leading & Trailing Spaces In Cell
https://youtu.be/BKT-I6OZ9ww
Extract Online Exchange Price
https://youtu.be/3e0G0IISEpI
***********************************************************
#PowerAutomate #PowerAddicts #ExcelExciting #FarazShaikh #Outlook #OneDrive #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #PowerAutomateTricks Save Email Attachments from Outlook To OneDrive - Power Automate](https://i.ytimg.com/vi/uOPJhFCPhNM/mqdefault.jpg)
![Create Excel Table with current sheet name (Excel For Mac & Windows)
In this video, we will see this VBA Code allows you to create Excel Table with the current sheet name using VBA. Usually, when we convert the data into Excel tables by default it is given with the Table1 and later we need to manually rename the table name. With this VBA code, it will take the active sheet name and update it automatically when we convert it to Excel Table.
00:00 Intro
00:29 Understanding the Scenario
00:59 Using Macro Recorder
02:07 Editing the VBA Code
05:09 Copy the VBA Code from Website
05:33 Validation Error Table cannot overlap another table
06:00 Checking the code & Important Notes
07:10 End
๐ 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.
Copy the VBA Code from the Website
https://excelexciting.com/convert-active-sheets-data-into-excel-table-by-sheet-name-with-vba/
๐ 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/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
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
Excel Tip by the Excel Queen ๐ธ๐ป(Faraz & Leila)
https://youtu.be/6CEYKRIlppE
Two Best Excel Tricks by Excel Experts
https://youtu.be/ihVtnUDTCBM
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #ExcelVBA #ExcelMacro Create Excel Table with current sheet name (Excel For Mac & Windows)](https://i.ytimg.com/vi/uQOtQtr2nDk/mqdefault.jpg)