H hostelowner Board Regular Joined Apr 19, 2005 Messages 105 Nov 16, 2005 #1 hello, how can i move data listed on 1 row 10 columns into 1 column 10 rows.. thanks
L Legacy 51064 Guest Nov 16, 2005 #2 I would either use the transpose formula or edit-paste special - transpose function: If your data is in column A3:J13 Highlight A4:A14 and type in this formula and press ctrl+shift+enter =TRANSPOSE(A4:A14)
I would either use the transpose formula or edit-paste special - transpose function: If your data is in column A3:J13 Highlight A4:A14 and type in this formula and press ctrl+shift+enter =TRANSPOSE(A4:A14)
Mark O'Brien MrExcel MVP Joined Feb 15, 2002 Messages 3,530 Nov 16, 2005 #3 1. Highlight the data 2. Hit CTRL+c to copy data 3. Select the cell that the first piece of data is to be located in 4. From the toolbar choose "EDIT|Paste Special" 5. Select the "Transpose" option 6. Hit "OK"
1. Highlight the data 2. Hit CTRL+c to copy data 3. Select the cell that the first piece of data is to be located in 4. From the toolbar choose "EDIT|Paste Special" 5. Select the "Transpose" option 6. Hit "OK"
H hostelowner Board Regular Joined Apr 19, 2005 Messages 105 Nov 16, 2005 #4 thanks awsome.... thank you both