1. 

   kaushik03
   

   Member
   Joined: Sep '11
   Posts: 776

   How to transpose data(rows to column) from different rows of a worksheet?

   Posted 1 year ago #
2. 

   Hui
   

   Excel Ninja
   Joined: Jul '09
   Posts: 5,181

   Kaushik03

   Firstly, Welcome to the Chandoo.org Forums.

   Select the Rows or Data
   Copy (Ctrl C)
   Select the upper left corner where you want the data copied
   Paste Special, Transpose (Ctrl Alt V, e)

   Note: You can't Cut and Transpose.

   Posted 1 year ago #
3. 

   Indian
   

   Member
   Joined: May '11
   Posts: 273

   Or you can use the array =TRANSPOSE function......Select all the count of rows/columns you want to copy type =transpose and give the array of referenced rows/columns...

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums