Help! How can I expand a set of columns?
Posted by Jeremy on December 20, 2001 2:31 PM
This is the information I have, in columns
A Horse
B Dog
C Cat
D Mouse
Desired output would be (in one column)
A Horse
A Dog
A Cat
A Mouse
B Horse
B Dog
B Cat
B Mouse... and so on. I have many columns that need to be combined like that and reference each other.
Thanks!!
Posted by Chris D on December 21, 2001 4:34 AM
No pun intented, but could you conCATenate them ?
Insert column before existing column A
then in new A1 type =B1&C1&D1&E1
copy down as far as needed
repeat for each set of columns
(or with spaces it would be =B1&" "&C1&" "&D1&" "&E1)
is that what you had in mind ?
Chris
