G Guest Mar 1, 2006 #1 How do you convert the column fields into rows? for ex: from 1 2 3 4 to 1 2 3 4 Any help wld be appreciated
How do you convert the column fields into rows? for ex: from 1 2 3 4 to 1 2 3 4 Any help wld be appreciated
G Guest Mar 1, 2006 #2 Try this: Select the vertical list Edit|Copy Select a destination cell Edit|Paste Special Check: Transpose Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP-Pro
Try this: Select the vertical list Edit|Copy Select a destination cell Edit|Paste Special Check: Transpose Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP-Pro
G Guest Mar 1, 2006 #3 It works, Thanks a lot Ron Coderre said: Try this: Select the vertical list Edit|Copy Select a destination cell Edit|Paste Special Check: Transpose Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP-Pro nick said: How do you convert the column fields into rows? for ex: from 1 2 3 4 to 1 2 3 4 Any help wld be appreciated Click to expand... Click to expand...
It works, Thanks a lot Ron Coderre said: Try this: Select the vertical list Edit|Copy Select a destination cell Edit|Paste Special Check: Transpose Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP-Pro nick said: How do you convert the column fields into rows? for ex: from 1 2 3 4 to 1 2 3 4 Any help wld be appreciated Click to expand... Click to expand...