21. Convert Columns to Rows in Excel |NO Transpose| NO Formulas | SIMPLY UNPIVOT IN Power Query
To convert columns to rows in Microsoft Excel without using formulas or the Transpose feature, you can use the "Unpivot" feature in Power Query. Here's how:
Click on the "Data" tab in the Excel ribbon, and then select "Get & Transform Data" "From Table/Range".
Select the columns that you want to convert to rows and click "Load".
In the Power Query Editor, click on the "Transform Data" button.
In the Power Query Editor, click on the "Unpivot Columns" button.
In the "Unpivot Columns" dialog box, select the columns that you want to convert to rows.
Click the "Apply & Close" button.
Your columns will be converted to rows, and the resulting data will be displayed in a new sheet in your workbook.
The Unpivot feature in Power Query is a simple and effective way to convert columns to rows in Excel. It allows you to easily change the structure of your data without the need for formulas or other complicated techniques. Additionally, Power Query provides a user-friendly interface that makes it easy to work with your data and make any necessary transformations.
Learn About Below Topic Content In This Channel
01) Microsoft Visual Basic ( Excel VBA, Macro)
02) Microsoft Excel Tutorial In Bangla
03) Microsoft Word Tutorial In Bangla
04) Microsoft Powerpoint Tutorial In Bangla
05) Computer Tips And Tricks In Bangla
COMMUNICATE WITH HASAN ACADEMY
[email protected]
#HasanAcademy #Power_Query #Power_Query_Bangla
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650
Facebook page link : / hasanacademybanglatutorial
Most popular video Link :
• Excel VBA Bangla Tutorial 48 : Data E... • Excel VBA Bangla Tutorial 50 : Create... • Excel tutorial Bangla 24 : Top 10 Use... • Excel VBA Bangla Tutorial 54: Add- Em... • Introduction to Pivot Tables-Charts-a... • Excel VBA Bangla Tutorial 49 : Invoic...
Most of the people is think about that how I will learn .But they didn't get any idea & trustworthy source. Don't hesitated Hasan Academy with you. You will learn from here, Excel, Excel Chart, Pivot Table, Vlookup, Formula function