No Merging | Power Query | R.O.C.K. Your Data | EP 003 | Excel Sifu

Referring to the [R.O.C.K. Your Data] book, this online meet was to show 3 ways to achieve result metnioned at page 29.

The intention of this book club meet is to help more to make friends with their data, especially those have obtained a copy of [R.O.C.K. Your Data].
The downloadable file
https://docs.google.com/spreadsheets/d/1gYtIQlbK5t4R90hHQp8yHxrV_GoS3R98/edit?usp=drive_link&ouid=116068563422181575654&rtpof=true&sd=true
Timing
00:00 Welcoming
00:29 The Scenario
01:33 Using Power Query to Handle Merged Cells of an External File
05:50 Doing some testing
06:20 Closing
Download eBook: The 5 Magic to Master Business Data
👉 https://5-secrets-biz-data.mailerpage.com

Follow Me in Odyess
👉 https://odysee.com/@ExcelSifu

Join Me in Odyess
👉 https://odysee.com/$/invite/HuxeoXKaUnv7eyTNkiYmNxUamL7rJjhT

Connect to me in LinkedIn
https://www.linkedin.com/in/excelsifu

Like our Facebook
https://www.facebook.com/WhyExcel/

Hash Tag
#ExcelSifu #MicrosoftExcel

Видео No Merging | Power Query | R.O.C.K. Your Data | EP 003 | Excel Sifu канала ExcelSifu