If you are not averse to the R language, https://r4ds.hadley.nz/data-tidy is a good resource for skills and ideas that generalize beyond "tidyverse" and R.

If you want a GUI-based approach then Easy Data Transform have various data wrangling related videos:

https://www.youtube.com/@EasyDataTransform

I think you're interested in keyword: ETL (Extract, transform, load)

(Specifically the "transform" part.)

- https://en.wikipedia.org/wiki/Extract,_transform,_load

- https://hn.algolia.com/?q=etl