The way I’d do this is to run a Haiku column (Integration: Claude: Generate text) with a prompt normalizing all of this.
If you know exactly what inputs you have formulas may be good, too, but I’d guess this will vary a lot in your list.
The Haiku thing only makes sense if you use your own API key, then it’s almost free (like $ 0.002 or something like that per row).
HMU if you have questions, happy to help