Aug 13 2021 06:23 AM
Hi,
I have a csv file where in column A there are IDs, and in column B there are associated data. The data is separated with a semicolon (;). And the hardest bit is if one data point shares the same category with another data, then their category name precedes it with a colon (:) between them. So something like this:
column A Column B
thisisID abc;cat1:xyz;cat1:yyy,cat1:zzz;cat2:ddd,cat2:eee
I want to transform this format to another format where,
Column A (ID) Column B (abc) Column C (cat1) Column D (cat2)
thisisID abc xyz|yyy|zzz ddd|eee
Is there any formula to change the format to the new format? Maybe this is something that a formula cannot solve. Any advise/help is appreciated.
Aug 15 2021 10:13 AM
Aug 15 2021 10:48 AM
Aug 15 2021 10:49 AM