Normalization of Unit of Measure

1

What is the best (quickest, easiest to maintain, etc) way to normalize a large dataset across multiple columns for many different unit of measures?

For example, if I want to normalize the word "Gallons" or "Gallon" to "gal" within about 150 different columns what is the best approach? Is it just the "Table-Wide Replace" function? Would that approach still be the most efficient if I had a spreadsheet of 600+ normalization unit of measures - I'd list out the table wide replace function 600 times?

Here is a sample of that 600 listing:

image
image532×364 5.49 KB

2

If that needs to be applied to multiple columns, I'd do "Iterate columns" and in the iterated module, I'd use "Replace with a lookup".

If you need a more detailed explanation, let me know.

3

Ahh ok I think that should work. I'll give it a try in the next couple days and if I have questions I'll come back here. Thanks!