Excel version: 2013
Problem:
Hi everyone!
I'm an economics student researching for my master thesis on 3D printing,
I was trying to create a database of 3D printers with various informations (Company, Model, Materials etc.) where 1 material coincided to one row.
My problem started when I downloaded (copying it with ctrl + A) a list of 3D printers from the Senvol site -> link to online DB
A fantastic site with a big problem (concerning an excel DB), the materials did not coincide to one row but are listed inside one cell separated by just one ", " (comma & space).
I tried everything to keep the Model name and information and just spread the material names over new rows but with little luck (I tried to edit the text to columns function with VBA, after transposing the DB, but also in this case with little luck).
You can see a picture below to better understand the problem.
I hope there's someone more skilled than I'm to help me out.
Thanks,
Aen
Problem:
Hi everyone!
I'm an economics student researching for my master thesis on 3D printing,
I was trying to create a database of 3D printers with various informations (Company, Model, Materials etc.) where 1 material coincided to one row.
My problem started when I downloaded (copying it with ctrl + A) a list of 3D printers from the Senvol site -> link to online DB
A fantastic site with a big problem (concerning an excel DB), the materials did not coincide to one row but are listed inside one cell separated by just one ", " (comma & space).
I tried everything to keep the Model name and information and just spread the material names over new rows but with little luck (I tried to edit the text to columns function with VBA, after transposing the DB, but also in this case with little luck).
You can see a picture below to better understand the problem.
I hope there's someone more skilled than I'm to help me out.
Thanks,
Aen
Last edited:
