Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate | Excel Worksheet Functions | |||
CONCATENATE | Excel Worksheet Functions | |||
IF, IF, Concatenate? | Excel Worksheet Functions | |||
CONCATENATE | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |