Microsoft Excel, convert column of objects to comma separated strings.
Bütçe $10-30 USD
I have a column that contains an object in each row, and that column is titled spokenLanguages:
Example:
a:3:{
i:0;a:2:{
s:14:"languageAbbrev";s:2:"AA";s:12:"languageName";s:9:"Afrikaans";
}
i:1;a:2:{
s:14:"languageAbbrev";s:2:"HB";s:12:"languageName";s:6:"Hebrew";
}
i:2;a:2:{
s:14:"languageAbbrev";s:2:"SP";s:12:"languageName";s:7:"Spanish";
}
}
I want to take that object, and just have a comma separated list of the languageName variable. So in this example, it would be:
Afrikaans,Hebrew,Spanish
Seçilen:
Hello, this is definitely possible. If you can please attach a sheet with more samples so i can see whether this can be solved with formula or with macros. I am available right now. Thanks, Milan
Bu iş için 16 freelancer ortalamada $19 teklif veriyor
Hello Sir/Madam Ready to start now. I can do your project with 100% accuracy. I have reviewed your project brief carefully and would like to assist you with the task.I have 8 years experience of data entry virus task, Daha Fazla
Helli It is with great pleasure to work on this project. I have worked on similar projects before you can see them in my portfolio and I have experience over 7 years working on Microsoft Office programs and data entry. Daha Fazla
Hi, I understand the requirement. I have an advanced knowledge on Excel's different formulas including pivot charts and visual basic coding. I can help you finish the project as soon as possible.
Hi - I have 15+ years working with excel and excel VBA creating reports, templates and data analysis. You can check my portfolio for sample work. Send me a message if you find me suitable. Thank you!
Hi I’m Mizanur. I am interested in this project. I am an expert Freelancer. I will do it. My services you will never be disappointed and I will never let you down with the quality of output. So trust and order me to c Daha Fazla
Esteemed client I am data analyst with excellent skills in excel. I will help to separate list of the language Name variable as shown in the example you have provided. I assure you of quality work within the set deadli Daha Fazla
Hello i knowledge of Excel, excel macro and visicul basic, c#. i can do things easly with programming.
Hi, I have gone through your description i have all the skills required for this project. Thank you
Estudiante del último año de ingeniería civil, soy responsable y muy buena con los números, dedicada ordenada y manejo de un Excel avanzado.
Hii, i can handle your assignment with 100% [login to view URL] get into touch with me.I have experience over 8 yeas working as professional now i am looking to start earning with online assignment.
I can extract the data as you desired and I will deliver your work on your expected time.I did get your requirement.