Microsoft Excel, convert column of objects to comma separated strings.
$10-30 USD
Bezahlt bei Lieferung
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
Projekt-ID: #29479131
Über das Projekt
Vergeben an:
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
15 Freelancer bieten im Durchschnitt $19 für diesen Job
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.
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 Mehr
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!
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.
I can extract the data as you desired and I will deliver your work on your expected time.I did get your requirement.