Pivot Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/pivot/ Bestselling Excel and Power BI Courses Tue, 25 Apr 2023 13:37:37 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Pivot Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/pivot/ 32 32 Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) https://www.xelplus.com/excel-switch-columns-multiple-values/ Thu, 29 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9917 Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

The post Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) appeared first on Xelplus - Leila Gharani.

]]> Google Sheets QUERY Function Explained https://www.xelplus.com/google-sheets-query-function/ Tue, 29 Dec 2020 18:42:00 +0000 https://www.xelplus.com/?p=8961 The Query function in Google sheets is one of the most powerful Google Sheets functions. It's easy to learn if you follow the rules laid out in this tutorial. You'll be ready to solve any data analysis problem in Google Sheets.

The post Google Sheets QUERY Function Explained appeared first on Xelplus - Leila Gharani.

]]>