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 ... https://www.youtube.com/watch?v=UdOJCf8nDV8