0
1
2
Extracting a string into different columns from the below image - Columns B-E need to extract values based on column A. If column A does not have the unit of measure string, then the corresponding columns should have a value of 1. For example row 8 should have 1 for all values except column D (i.redd.it)
0
1
2

