I want to assign a category to a table so that I can eventually create a pivot table.
I need to do a partial match to get my category values.
"num" i want to match to "number 111" and "numeric 321" and then assign both of those as category1.
"form" i want to match to "Form 1" and "formula" as category2 and so on.
<tbody>
</tbody>
I need to do a partial match to get my category values.
"num" i want to match to "number 111" and "numeric 321" and then assign both of those as category1.
"form" i want to match to "Form 1" and "formula" as category2 and so on.
Group | Assigned catorgories | Matching critera | Categories | |
Number 111 | num | category1 | ||
Numeric 321 | form | category2 | ||
Form 1 | data | category3 | ||
Uncategorized | misc | category4 | ||
test data | ||||
prod data | ||||
formula |
<tbody>
</tbody>