Replace Values Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/replace-values/ Bestselling Excel and Power BI Courses Mon, 24 Apr 2023 11:26:45 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Replace Values Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/replace-values/ 32 32 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.

]]>