transfer data into row cells from column cells in Excel
I'm looking for a way to to quickly transfer data from cells in a column in
one sheet of an excel workbook to cells in a row in another sheet of the same workbook. It's a simple matter if the cells in both sheets are in columns as you can just make the first cell equal the first cell of the column that you want the data to come from, and then drag and drop from that one down to the other cells in that column til you have transferred all the information required. I haven't worked out how to do this when you are going from column to row or vice-versa. Anybody got any ideas, please. |
transfer data into row cells from column cells in Excel
Bernard
=INDIRECT("Sheet2!A"&COLUMN(A1)) Enter in any cell in Sheet1 and drag across. Gord Dibben MS Excel MVP On Sat, 12 Aug 2006 11:31:01 -0700, Bernard Modlinsky <Bernard wrote: I'm looking for a way to to quickly transfer data from cells in a column in one sheet of an excel workbook to cells in a row in another sheet of the same workbook. It's a simple matter if the cells in both sheets are in columns as you can just make the first cell equal the first cell of the column that you want the data to come from, and then drag and drop from that one down to the other cells in that column til you have transferred all the information required. I haven't worked out how to do this when you are going from column to row or vice-versa. Anybody got any ideas, please. |
transfer data into row cells from column cells in Excel
Hi!
Try this: =INDEX($A5:$A10,COLUMNS($A:A)) Copy across as needed. Biff "Bernard Modlinsky" <Bernard wrote in message ... I'm looking for a way to to quickly transfer data from cells in a column in one sheet of an excel workbook to cells in a row in another sheet of the same workbook. It's a simple matter if the cells in both sheets are in columns as you can just make the first cell equal the first cell of the column that you want the data to come from, and then drag and drop from that one down to the other cells in that column til you have transferred all the information required. I haven't worked out how to do this when you are going from column to row or vice-versa. Anybody got any ideas, please. |
transfer data into row cells from column cells in Excel
I just have a preference for the non-volatile Index():
Data on Sheet1, in Column A. Enter this anywhere in another sheet. and copy across as needed: =INDEX(Sheet1!$A:$A,COLUMNS($A:A)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Bernard =INDIRECT("Sheet2!A"&COLUMN(A1)) Enter in any cell in Sheet1 and drag across. Gord Dibben MS Excel MVP On Sat, 12 Aug 2006 11:31:01 -0700, Bernard Modlinsky <Bernard wrote: I'm looking for a way to to quickly transfer data from cells in a column in one sheet of an excel workbook to cells in a row in another sheet of the same workbook. It's a simple matter if the cells in both sheets are in columns as you can just make the first cell equal the first cell of the column that you want the data to come from, and then drag and drop from that one down to the other cells in that column til you have transferred all the information required. I haven't worked out how to do this when you are going from column to row or vice-versa. Anybody got any ideas, please. |
All times are GMT +1. The time now is 02:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com