Splitting comma delimited keywords and combining in one column
Use case: For every account I have a set of comma delimited keywords stored in 1 column (think "SaaS,business,b2b,etc"). I ultimately want to create a list of all unique keywords, then compare that against my dataset to measure frequency ("How many accounts contain "SaaS"?) My feeble attempt: I've managed to split the…
