Need Excel/VBA solution to handle data-set
Budget: €8 – €30 EUR
Hello I need Excel or VBA solution(or maybe another) to handle this data-set.
I have values inside the table: named: name1:rrr(but convention is not fixed, so fine would be handling also other special characters than ":"). And I want to transpose it, and create table from values(please note, they are separated by space character!) and associate them with every group.
One constraint more- values can be doubled, also with other convention, so I just need to have only name, without ":rrr", make it unique. For example- it can be name1:rrr, name1:blabla, name1@something, and I need to handle and associate correctly just "name1".
I am uploading screen, hope it is clear, it is pretty complex to explain, thanks.
I have values inside the table: named: name1:rrr(but convention is not fixed, so fine would be handling also other special characters than ":"). And I want to transpose it, and create table from values(please note, they are separated by space character!) and associate them with every group.
One constraint more- values can be doubled, also with other convention, so I just need to have only name, without ":rrr", make it unique. For example- it can be name1:rrr, name1:blabla, name1@something, and I need to handle and associate correctly just "name1".
I am uploading screen, hope it is clear, it is pretty complex to explain, thanks.