Messy Data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/messy-data/ Bestselling Excel and Power BI Courses Mon, 24 Apr 2023 16:00:07 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Messy Data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/messy-data/ 32 32 How to Combine Excel Sheets with Power Query https://www.xelplus.com/combine-excel-sheets-power-query/ Thu, 30 Jul 2020 09:00:00 +0000 https://www.xelplus.com/?p=10838 Can you easily combine & clean data from multiple Excel sheets into a single table or Pivot Table? You can easily get this done in Excel with Get & Transform (aka Power Query). Check out the full post.

The post How to Combine Excel Sheets with Power Query appeared first on Xelplus - Leila Gharani.

]]> How to Transpose Mutliple Header Rows to Columns in Excel – Advanced Unpivot Techniques https://www.xelplus.com/excel-advanced-unpivot-power-query/ Thu, 16 Jul 2020 09:00:00 +0000 https://www.xelplus.com/?p=10862 You can easily use Excel Power Query to transpose a data-set with multiple row headers from multiple columns to rows. Find out how in this quick tutorial.

The post How to Transpose Mutliple Header Rows to Columns in Excel – Advanced Unpivot Techniques appeared first on Xelplus - Leila Gharani.

]]>