convert data into a list in excel 2
€30-250 EUR
Pagado a la entrega
The file is composed of 3 parts:
1/ column A to G: do not alter or modify
2/ Column H to BW:
for every line, do the following:
a) when you see a cell with the word situation, group the following cells together until
b) when you a cell with the word activités, group the following cells together until
c) when you see a cell with the word services, group the following cells together until
d) when you see a cell with the word info pratique, group the following cells together
3/ column BX to end
For every time you see the words (check caps) MOBILHOME, TENTE, CAMPING, YOURTE, BUNGALOW, bungalow toilé, Studio, APPARTEMENT, STUDIO, VILLA, then group the following cells together until you find the same word again, meaning it is a new product.
Lines have to remain unchanged, as we need all info in the same line with the ids
Nº del proyecto: #4636585
Sobre el proyecto
Adjudicado a:
Hello 'pabloszefner' I can start work right away. Please read PM for more detailed. Regards jjdatajobs
68 freelancers están ofertando un promedio de €100 por este trabajo
I have good skills in excel till verion 2013. I am good vb programmer. Expecting a call soon. Please check PM.
Hi, your excel and vba coding expert is ready to help you. kindly get back to me if you wish to proceed with a top-rated expert here...regards,
Good day! After reading the project description, im confident that i can do this job. I hope you will consider me for this job and i can start immediately.
Such jobs are my daily practice. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
Hello, Your original database seems to be corrupted, please see private message. Regards, Solt
How many records of data? I have done this same sort of manual entry work before and understand how databases work
Hello I am an Excel VBA expert. I have completed many projects similar to this one and I can quickly and easily build you a macro that will group the cells together on each row according to the special keywords. I Más
Hello Dear Pablo, i have checked out the file you provided, and can assure you that i can finish this simple task in 2 days with 100% accuracy, thanks