• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Convert column values in row values?

S

shrutikul.07

New Member
Hi chandoo


m facing a problem in converting the column values into row values. I have searched it in the given options but i didn't found it? Please help me?
 
Hi


Use Copy / Paste Special-> Transpose


you will find this in Cpoy Paste on the Menu or Ribbon
 
Hi


You copy the whatever you need, select the paste function on the menu and then select transpose
 
Hello Friends,

I am facing problem in converting row values to column based on Heading.

Please help me in overcoming this problem.

Enclosed the file for your reference.

Regards,
Anbu
 

Attachments

  • Sample worksheet.xlsx
    9.2 KB · Views: 5
You should've started a new thread. This can be done using formula but the fields are little inconsistent. But this can be fixed easily through code. Is that acceptable?
 
Thanks for your reply, Shri.

Moving forward i will start a new thread regarding my queries.

Yes, it is acceptable.

Please help me with a solution.

Regards,
Anbu
 
You must log in or register to reply here.
Back
Top