TRANSPOSE Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/transpose/ 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 TRANSPOSE Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/transpose/ 32 32 How to Use Excel BYROW and BYCOL Helper Functions for LAMBDA https://www.xelplus.com/excel-byrow-bycol-functions/ Thu, 23 Sep 2021 08:00:00 +0000 https://www.xelplus.com/?p=8880 Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.

The post How to Use Excel BYROW and BYCOL Helper Functions for LAMBDA appeared first on Xelplus - Leila Gharani.

]]> 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.

]]> How to Use Excel’s STOCKHISTORY Function https://www.xelplus.com/excel-stockhistory-function/ Thu, 28 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=8967 The StockHistory Function in Excel allows you to easily pull historical stock data in Excel with a single formula. You can get daily, weekly or monthly data. Find out how to use this together with sparklines to visualize the trend of different stocks in one view.

The post How to Use Excel’s STOCKHISTORY Function appeared first on Xelplus - Leila Gharani.

]]> How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-multiple-dependent-dropdown-lists/ Tue, 15 Dec 2020 12:40:00 +0000 https://www.xelplus.com/?p=9182 There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check it out here.

The post How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Create Excel Searchable Drop-Down Lists for Every Row https://www.xelplus.com/excel-searchable-drop-down-every-row/ Thu, 16 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11372 Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it much easier to find an item from a large data validation list.

The post How to Create Excel Searchable Drop-Down Lists for Every Row 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.

]]> Excel Hack to Change Horizontal Data to Vertical https://www.xelplus.com/excel-horizontal-data-to-vertical/ Sat, 11 May 2019 20:40:00 +0000 https://www.xelplus.com/?p=12358 Here's an Excel Hack that shows an unusual but simple method to change horizontal data to vertical. The advantage of this hack is it's dynamic so if you add more values to the horizontal data it will reflect in the vertical one.

The post Excel Hack to Change Horizontal Data to Vertical appeared first on Xelplus - Leila Gharani.

]]> Quick Excel Trick to Unstack Data from One Column to Multiple Columns https://www.xelplus.com/unstack-data-to-multiple-columns/ Sat, 12 Jan 2019 02:15:00 +0000 https://www.xelplus.com/?p=9820 Find out the quickest way to unstack data in Excel from one column to multiple columns. You don't need complicated excel formulas or VBA. Find out how in this tutorial.

The post Quick Excel Trick to Unstack Data from One Column to Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> Excel Dependent Combo Box Solves an Annoying Problem https://www.xelplus.com/dependent-combo-box/ Sat, 08 Dec 2018 01:41:00 +0000 https://www.xelplus.com/?p=9841 Combo boxes are a good alternative to data validation drop-down lists in Excel. Learn how to create a dependent combo box in Excel. This combo box ends up solving an annyoing Excel "reset" problem.

The post Excel Dependent Combo Box Solves an Annoying Problem appeared first on Xelplus - Leila Gharani.

]]> 3 Ways to Transpose Excel Data https://www.xelplus.com/transpose-excel-data/ Fri, 09 Nov 2018 12:02:00 +0000 https://www.xelplus.com/?p=9884 2 of the methods shown to transpose data in Excel are dynamic. Number 3 will surprise you. It will show you a simple way to switch your data from rows to columns or vice versa.

The post 3 Ways to Transpose Excel Data appeared first on Xelplus - Leila Gharani.

]]>