Excel Trick#56 : How To Transpose Multiple Columns And Rows Into Single Column || dptutorials

In this tutorial, let us learn How To Transpose Multiple Columns And Rows Into Single Column

Best Laptops to use for better speed:

Here in this example, I have the data range in A3:C6, and let us try to transpose this data table into a single column.

Now, I enter the formula in E3 as =INDEX($A$3:$C$6,1+INT((ROW(A1)-1)/COLUMNS($A$3:$C$6)),MOD(ROW(A1)-1+COLUMNS($A$3:$C$6),COLUMNS($A$3:$C$6))+1)

and press Enter.

You will get the result as the value of first cell i.e A, drag this formula till you get an error message #REF!

You can delete the #REF! now you can clearly see that you have got the desired result of transposing multiple column data into a single column data.

Our Recommendations
***************************************************************

If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.

***********************************************

⚡️Tools for YouTube vlogging:
***********************************************

***********************************************

⚡️You Can Connect with Me at:
***********************************************

#dptutorials #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning

⚡️Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in English,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, Excel Sum Formula, Sum Formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft excel training,attendance sheet in excel,excel data entry,excel formulas and functions,microsoft excel 2007, ms excel tutorial, excel formulas, and functions in hindi, excel formulas and functions tutorial, excel formulas in english, excel formulas in hindi, excel in english, excel in hindi, excel tutorial in english, excel tutorial in hindi, ms excel 2007,ms excel in english, salary sheet in excel, tutorial excel, excel stock maintain, learn excel in english, learn ms excel in english, ms excel tutorial in english, sum formula series,vlookup in excel in english

[mustafagls]

Thanks a lot. It worked. I've been looking into dozens of websites without getting the right solution. You helped me gather over 5000 values in 40 columns and 128 rows together!. Keep up the good work, and thanks again.

[timmytesla]

You have no idea how much you have saved me. I had over 300 sheets to do this on. Thank you very very much!

[ricardoglopes]

While seeing you typing that formula, I smiled and thought to myself. It must be a gentleman from India; only they can have this meticulous math approach to solving problems. Missing you guys!!

[mateo_elias]

Honestly, I can't say that I understand your formula, but you have saved me SO MUCH time! Thank you so much!

[maheshdhadge]

Thank you for useful tricks. thanks alot

[airkhan]

THANK YOU! I have been looking for this for a while!

[jchgqec]

Using this formula on 16-03-2023, it worked and saved my time ten times. Thanks a billion

[chiaraf.]

You really helped me thank you very much!

[deeplybuffalo]

Seriously thank you, saved me hours of work.

[csbadcocksfl]

Thank you so much!, this was a time-saver, It will be great if you explain the formula in detail.

[saithiru]

Thank you so much.... this tutorial help me a lot 🙏🏽

[xlombagio]

THANK YOU kind and generous soul. I'm grateful to you and your family

[VicSMeIsTeR]

Massive thanks, dptutorials, saved my skin definitely.

[MPisMoE]

It worked well. Thank you. I would have loved an explanation of why the formula was formed this way to better understand it.

[sivasankarcss]

WOW SAVED LOT OF MY TIME.. KEEP POSTING...

[erycklelann]

Excellent video.
Thank you for your work.
Have a great day

[pannagesh]

Sir, I am happy to see this . Really great and excellent

[wonchventures]

This worked like magic. Thank you so much. I saved tons of hours because of this.

[AnishKumar-bjbg]

Hi, thank you for sharing this formula, it saved a lot of time in my case. Keep sharing such videos. 👍

[vaseembaig]

Superb trick --- you sir are amazing! Thank you very very much --- saved me hours of copying data!!!!