Hello!
I am importing messy data entered over many years in many different formats. I am hoping there is an easy way to merge similar single select fields in one.
For instance, in the screenshot below there are 50+ ways that people have entered this info over the years, but I would like to consolidate those into under 10 categories. So I would want to take the “Large” single select option and then pull in the various fields such as: “lg” “Lg” “large shade” “large?” etc.
Hoping there is a simpler way to do this because there’s a large volume of records.
Thank you for any thoughts!
