Transform data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/transform-data/ Bestselling Excel and Power BI Courses Tue, 22 Aug 2023 00:53:52 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Transform data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/transform-data/ 32 32 Properly Convert PDF Files to Excel https://www.xelplus.com/import-pdf-to-excel/ Thu, 15 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10614 Learn to properly convert PDF files to Excel without losing any formatting. With this method you can even refresh your Excel result to grab the latest data from your PDF file.

The post Properly Convert PDF Files to Excel appeared first on Xelplus - Leila Gharani.

]]> How to Easily Import Data from Web to Excel https://www.xelplus.com/import-data-from-web-to-excel/ Sun, 15 Dec 2019 02:53:00 +0000 https://www.xelplus.com/?p=11661 Quickly learn how to import data from a web page into Excel with these 2 practical examples. The advantage of importing data this way is that whenever the data on the website is updated, you'll just need to "refresh" the data in Excel to get the latest information. It's super easy!

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

]]> How to Switch Data in Columns to Rows in Excel with Power Query https://www.xelplus.com/excel-powerquery-transpose-unpivot/ Thu, 19 Sep 2019 09:00:00 +0000 https://www.xelplus.com/?p=12112 Here is the easiest way you can switch data from columns to rows in Excel. It involves NO formulas, NO Transpose - just simply UNPIVOT with Get & Transform. After-all tabular data sets are easier to work with.

The post How to Switch Data in Columns to Rows in Excel with Power Query appeared first on Xelplus - Leila Gharani.

]]>