How to convert from Foot, Inch to cm in Power Query Editor

[@adeniranye]

i was about to lose my mind trying to convert this column to centimeters. Thanks for sharing this

[@adeniranye]

Multiplying by 0.393 gave me unexpected values in cm, maybe it was an error on my part but I rectified it by multiplying with 2.54.

[@LearnwithUD1]

You are welcome. Are you sorted now?

[@adeniranye]

@@LearnwithUD1Yes for now. I'm still in the process of cleaning and writing a story on Medium

[@amieolivia]

Thank you for taking your time to break this down ❤

[@LearnwithUD1]

Glad it was helpful💛