Hi,
I have two spreadsheets and on say Spreadsheet 1 I have two rows (rows 1 & 2) from column A to AE.
On Spreadsheet 2 I want a formula that will copy in column A all the data that is in Spreadsheet 1 from A1 to AE2 and then in Column B do the same for A2 to AE2. So basically converting the horizontal presentation of the data into a vertical column.
I know how to drag formulas down but unsure on the horizontal to vertical dragging.
Any help would be great, thanks.
(Excel 2002)
Lew
Bookmarks