Discussion Groups Home

How can i convert the rows into columns and columns into rows? in Excel Worksheet Functions

8/6/2005 11:19 PM PST

Question

	Hi, I have a table consists of columns and rows,just i want to convert every column to be a row and every row to be column . Thanks in advance.

Was this post helpful to you?

8/6/2005 11:54 PM PST

Answer

	edit-copy-edit- pastespecial- transpose Yasser <Yasser@discussions.microsoft.com> wrote in message news:E23A572F-25D1-4506-AEA9-B4B86FD6F222@microsoft.com... > Hi, > I have a table consists of columns and rows,just i want to convert every > column to be a row and every row to be column . > Thanks in advance.

Was this post helpful to you?

	Return to Microsoft Communities		Notify me of replies