Here's a very small version of what I want to accomplish but can't figure out exactly what to look for on Google –
Column A | Column B Alice | Present Bob | Absent
Should translate into –
Present Absent Alice True Bob True
So basically every unique value in
column B should become a new column and the intersection of the row and column should be
Further expansion –
It's more complicated, but is that 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 have the same weight, but each tag is in a different column.
Thank you in advance.