Moving Text from One cell to another if it matches some set text

Not sure if this has to be done using a VBA macro or if there are formulas that can be used. It's been a few years since I was in high school and learning about using excel so a lot of my knowledge in this area has faded as I made room for different tasks. My current goal is to take an access database we have containing information about 1600 or so people and move it to our web based SQL server for better functionality. I have wrote the database and all the working reports for our web based database but our last step is to move over the 1600 people which can be easily imported, the problem is that the database scheme doesn't match the layout that it is in from the Access database. To give you an idea something in the Access Database may look like:

General Information
Something, Something1, Something2

where General Information is the Column Heading and the comma separated list is the column information. This in the online database is not something that requires parsing, it would be 3 seperate columns that contains the value of whatever it is instead of 1 column with all values seperated by commas. so.

Something | Something1 | Something2
Something | Something1 | Something2

Where Each column ends at the "|"

Is there a script that we could run on "General Information" where General information is some arbitrary column, we'll say C1 that would do something like

If C1 contains the string "something" write "something" in Column D1

D1 would be a new column named Something and At the conclusion of running the script across the 1600 results I could just delete the entire General information column.

How it is set up "something" would just be written in the new column and could be some user defined string. so "write 'something'" 'something' could equal anything I wish to set it equal to not just the value of "general information" (C1).

I am not sure how clear I am being but if you need more clarification please comment and I will do my best to address any questions. I haven't worked with VB in years and wouldn't know where to start with the VBA integration with excel. The reason we are straying from access is because our Access Database Administrator recently passed away and instead of reeducation someone to fill her position we figured we'd remake the application in a domain that more and more people can actively manipulate (php + sql). I am not a VBA expert and really hope that I can get this done without having to write a macro, time isn't a huge deal but I don't want to think about how much time it would take me to write the macros.

Any help would be much appreciated.

Attached image of how it will work:
Sample.PNG

Hi andylpsx,
Welcome to the Forum.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic