Here is a very small version of what I want to achieve but not able to figure out what exactly should I Google search for -
Column A | Column B Alice | Present Bob | Absent
Should translate to -
Present Absent Alice True Bob True
So basically, each unique value in
column B should become a new column and the intersection of row and column should be
Further extension - Its even more involved, but is this something achievable?-
Convert this -
Column A | HashTag 1 | HashTag 2 | HashTag 3 Alice | corona | staySafe | Bob | lucky | corona | blessed
corona staySafe lucky blessed Alice True True Bob True True True
Here all HashTag columns are of same weight, but each tag is in different column.
Thanks in advance.