1.

Solve : MS excel :- How can i convert columns in rows?

Answer»

Please help me how can i convert data in the column to rows without typing the same
for Eg: in A1=30,B1=32,C1=34        to             D1=30,D2=32,D3=34
Do you want to keep that values in the columns or will you DELETE them once you have them in rows?Select A1:C1, Copy, move your cell pointer to D1, right CLICK and select PASTE Special.  In the Paste Special dialog panel, put check mark in the box for Transpose and click OK.Nevermind.My post has the solution.  Now, if we can have some feedback from shebeershah ...



Discussion

No Comment Found