I have column with Multiple Values separated by new line character
Type is the column
ID Type
Type_A
01 Type_B
Type_C
I need new columns with values 1 or 0 for row (with ID 01) based on its presence for Type
ID Type Type_A Type_B Type_C
Type_A 1 1 0
01 Type_B
02 Type_A
Type_B
Type_C
| eval Type=split(Type,"
")
| chart count by ID Type