Excel Manipulation Using VBA or Other Means

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
I have a Master Excel sheet consisting of roughly 2678 observations all in one column. Each observation consists of information such as address, owner, number of beds, name of business etc.. The problem is that all of that info is contained within the same cell. I would like to take the information for each observation and space it out across multiple columns for each observation. The catch is that the data is not consistent across all observations and so the Text to Column function in Excel is not up to the job.

Skills required:
Data Processing, Excel
Additional Files: AL+Sample.xlsx
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

Hire bharanisrihari
$ 150
in 3 days
$ 88
in 3 days
$ 60
in 3 days
Hire RajHeartbeat
$ 50
in 1 days
Hire best4best
$ 30
in 0 days
Hire pkcyber
$ 35
in 1 days
$ 100
in 2 days
$ 50
in 5 days
$ 35
in 1 days
$ 99
in 3 days