Simple Trick to Combine Multiple Files with Headers on 2 Rows | Power Query | Power BI
In this video, I will show you how to easily merge 2 files together when they both have 2 headers on different rows and keep the header order and format from the latest saved file.
📁 Weekly Timesheet Datasets -
https://data.world/deanchereden/hr-da...
🔖c h a p t e r s 🔖
00:00 - Intro
00:23 - Overview
01:01 - Load in data
01:47 - Transform data - Create Steps
06:24 - Transform data - All Tables
10:03 - Final result
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - / deanchereden
🎵 Music - Misha, Jussi Halme - Higher https://chll.to/4ec991f9
🙌 Follow Misha
・ SoundCloud: https://chll.to/386e721b
・ Spotify: https://chll.to/5f0bc9ba
・ Apple Music: https://chll.to/5a239af3
・ Chillhop: https://chll.to/2b2bc310
🙌 Follow Jussi Halme
・ Spotify: https://chll.to/dd4a82d2
・ Apple Music: https://chll.to/4961c878
・ Chillhop: https://chll.to/eb17b45e
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - Bliss (A Felici...