In this tutorial, I'll show you How to TRANSPOSE non-contiguous data in Excel.
⬇️Excel Formulas with Examples:
excelkid.com/formula/
🎓 LEARN MORE in my Excel tutorials: excelkid.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love.
Here is our data set, and I want to change the layout. Simply type TRANSPOSE and add a range you want to use. The main problem is that the result array contains blank cells. Try using the FILTER function inside the TRANSPOSE formula. Add the first argument, the array you want to filter.
Highlight range B2, B13. The second argument is include, you can add your criteria here. Select the range again and use the not equal logical operator.
These rows are blank, so we can exclude these cells using a double quotation mark. Now, the result looks good.
Okay, what if we have more than one column? Modify the FILTER function.
Then, use multiplication here. You can check if both conditions are true at the same time.
#exceltips #exceltutorial #excel