select and move contents of columns to rows

LB_UK · May 24th, 2002, 07:25 AM

I'm working on a despatch note (sheet1) which enables the user to select one or more items from a "stocklist" sheet via a listbox. (the info is held in rows under column heading; Code, Description etc and pastes into the note in the same layout)
The "address" sheet has the same basic layout
for data,(horizontal in rows under column headings; Contact, Address1, etc to address 5).
I need to display the selected address in the note (sheet1) in the usual address format (I.e. each line below the previous one) Can anyone supply an idea/solution as to how to do this. Thanks

sann0638 · May 24th, 2002, 07:50 AM

The TRANSPOSE function sounds like what you are looking for. If your original range is A1:E5, and you want to put the contents into A2:A6, select A2:A6 and type =transpose(A1:E5) and press Ctrl-Shft-Entr, because it is an array formula.

Spreadsheet Solutions · May 26th, 2002, 11:19 PM

No need to use a function, a simple copy and "Paste Special", making use of the transpose selection is easy enough. Bit late, but for future users.

May 24th, 2002, 07:50 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	The TRANSPOSE function sounds like what you are looking for. If your original range is A1:E5, and you want to put the contents into A2:A6, select A2:A6 and type =transpose(A1:E5) and press Ctrl-Shft-Entr, because it is an array formula. __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 07:25 AM	#1
LB_UK New Member Join Date: Mar 2002 Posts: 20	I'm working on a despatch note (sheet1) which enables the user to select one or more items from a "stocklist" sheet via a listbox. (the info is held in rows under column heading; Code, Description etc and pastes into the note in the same layout) The "address" sheet has the same basic layout for data,(horizontal in rows under column headings; Contact, Address1, etc to address 5). I need to display the selected address in the note (sheet1) in the usual address format (I.e. each line below the previous one) Can anyone supply an idea/solution as to how to do this. Thanks

May 26th, 2002, 11:19 PM	#3
Spreadsheet Solutions New Member Join Date: May 2002 Posts: 1	No need to use a function, a simple copy and "Paste Special", making use of the transpose selection is easy enough. Bit late, but for future users.