excel file assistance separate out multiple information in single cells to their own columns

Completed Posted 2 years ago Paid on delivery
Completed Paid on delivery

I have an xlsx file which is regularly exported from a third party software supplier using Apache POI. It typically contains data point of an application which we use to decision the application. Some of the questions are dynamic (not always asked depending on the answers) and the file shows some of the questions and answers in the same cell. I need to get a solution where I can dump the data into a file and run a macro or something to separate the questions and answers into their own columns so I can use the data points for my reporting. I can send through the list of all the individual dynamic questions and the possible responses (or if free text) after I have quote for the work. I have other excel work which I could use help with and it would be good to have a relationship with someone who I can go to.

Excel Excel Macros Data Processing

Project ID: #32556297

About the project

5 proposals Remote project Active 2 years ago

Awarded to:

mrbrave

Hi, Using my experience of over 10 years of VBA development, I can complete and send you macro in 1 hour. When you run macro, it will ask you to select file. On file selection, it will separate questions and answers More

$20 AUD in 1 day
(291 Reviews)
6.9

5 freelancers are bidding on average $22 for this job

mhfsha

Hello sir/ madam I checked your project description. I can do Microsoft excel task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss more. Thank you. Regards, Saan More

$30 AUD in 1 day
(87 Reviews)
5.2
Amrsamra

very easy msg me please

$20 AUD in 1 day
(18 Reviews)
4.1
usmanbashir12100

Hello, I’d really like to work with you on this one if possible! I’m Usman . I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data ext More

$20 AUD in 7 days
(2 Reviews)
0.2
vijendra1994

I am the best candidate for this project because I have experience to finish the project on time with expected results. I have the track record to prove my competence, and my peers and colleagues will vouch for me. I w More

$20 AUD in 7 days
(0 Reviews)
0.0