Group By Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/group-by/ Bestselling Excel and Power BI Courses Thu, 13 Jun 2024 14:11:04 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Group By Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/group-by/ 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.

]]> Create Excel Filled Map Charts with Power Query https://www.xelplus.com/excel-filled-map-chart-using-power-query/ Thu, 02 Jul 2020 17:51:00 +0000 https://www.xelplus.com/?p=10886 Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

The post Create Excel Filled Map Charts with Power Query appeared first on Xelplus - Leila Gharani.

]]>