| View Question |
|
|
 | ||
|
| Subject:
combining data from various columns to create new data~
Category: Computers Asked by: lioco_technology-ga List Price: $25.00 |
Posted:
14 Feb 2005 23:49 PST
Expires: 16 Mar 2005 23:49 PST Question ID: 474768 |
I have an excel sheet with subjects and courses and the main focus of classes, that I need to automatically combine into one column. The problem is the data presents in three columns and in various parts of the text. So I need help working out a formula that will extrapalate specific data and create a list of categories, sub categories and sub sub categories automatically over 5000 lines. If anyone can help me with a formula for this using excel, your expertise would be greatly appreciated, and rewarded! |
| ||
|
| There is no answer at this time. |
| ||
|
| Subject:
Re: combining data from various columns to create new data~
From: dikw-ga on 15 Feb 2005 04:14 PST |
Can you provide an example? |
| Subject:
Re: combining data from various columns to create new data~
From: wisecarlos-ga on 15 Feb 2005 10:40 PST |
CONCATENATE is the Excel funtion that you need to use for this. Carlos |
| Subject:
Re: combining data from various columns to create new data~
From: wyverncargo-ga on 16 Feb 2005 02:01 PST |
you need fast solution? |
| Subject:
Re: combining data from various columns to create new data~
From: nnarsi-ga on 27 Feb 2005 16:06 PST |
it is not clear what you want to accomplish. Send me a sample of your file with existing data and how you want the data to be transformed. Send your excel file to narsi.n@gmail.com |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
| Search Google Answers for |
| Google Home - Answers FAQ - Terms of Service - Privacy Policy |