CONCATENATE
Short sample approach:
In a new WB:
Get this data into Column A1:A4
F0255 111
F0255 112
F0255 113
F0255 114
Goto Menu Data, Text to Columns
Should change data to:
A B
F0255 111
F0255 112
F0255 113
F0255 114
Now go out to cell, say D1 (click-on) and Highlight cells D1:G2
This selection is based on the fact that you will be (shortly)
converting 4 rows and 2 columns to 4 columns and 2 rows.
With cells D1:G2 highlighted (with D1 still the active cell, enter
=TRANSPOSE(A1:B4) <<< Do not press the enter key, instead press the
combination of the Control, the shift and the enter key simultaneously.
Once you do that the full range D1:G2 will fill with the function including
{} around all the cells -- Making then Array formulas
Drop down to D6 and enter:
=D1&" "&D2&","&E2&","&F2&","&G2&","
That should get you to the look --- F0255 111,112,113,114,
HTH
From: "oren"
Subject: CONCATENATE
Date: Sunday, July 20, 2003 6:30 AM
Hello,
I have a big problem that I am trying to solve with no luck!
I am using Excel to connect to my company oracle database by using ODBC, and
programming SQL lines to determine conditions.
My problem is that I am trying to use the function CONCATENATE to string my
database (not working in SQL) so my last option is to generate Macro program
to do the Job (my data is very large).
Here is actually what I am trying to do:
DATABASE: CAR OPTION
F0255 111
F0255 112
F0255 113
F0255 114
RESULT: CAR OPTION
F0255 111,112,113,114,
Any suggestions ???????????
Many Thanks,
Oren
From: "oren"
Subject: CONCATENATE
Date: Sunday, July 20, 2003 6:30 AM
Hello,
I have a big problem that I am trying to solve with no luck!
I am using Excel to connect to my company oracle database by using ODBC, and
programming SQL lines to determine conditions.
My problem is that I am trying to use the function CONCATENATE to string my
database (not working in SQL) so my last option is to generate Macro program
to do the Job (my data is very large).
Here is actually what I am trying to do:
DATABASE: CAR OPTION
F0255 111
F0255 112
F0255 113
F0255 114
RESULT: CAR OPTION
F0255 111,112,113,114,
Any suggestions ???????????
Many Thanks,
Oren
"oren" wrote in message
...
Hello,
I have a big problem that I am trying to solve with no luck!
I am using Excel to connect to my company oracle database by using ODBC,
and
programming SQL lines to determine conditions.
My problem is that I am trying to use the function CONCATENATE to string
my
database (not working in SQL) so my last option is to generate Macro
program
to do the Job (my data is very large).
Here is actually what I am trying to do:
DATABASE: CAR OPTION
F0255 111
F0255 112
F0255 113
F0255 114
RESULT: CAR OPTION
F0255 111,112,113,114,
Any suggestions ???????????
Many Thanks,
Oren
|