Merge Columns Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/merge-columns/ Bestselling Excel and Power BI Courses Fri, 14 Jun 2024 15:07:26 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Merge Columns Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/merge-columns/ 32 32 How to Bulk Import Data from PDF to Excel https://www.xelplus.com/bulk-import-pdf-files-to-excel/ Mon, 20 Jun 2022 14:18:00 +0000 https://www.xelplus.com/?p=9102 Use this button you already have in Excel to bulk combine and import PDF files to Excel. Forget copy, paste, manually typing values or using 3rd party tools. Get it dynamic too so you just need to drop a new PDF in a folder and the data is immediately imported to Excel.

The post How to Bulk Import Data from PDF to Excel appeared first on Xelplus - Leila Gharani.

]]> How to Transpose Multiple 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 Multiple Header Rows to Columns in Excel – Advanced Unpivot Techniques appeared first on Xelplus - Leila Gharani.

]]>