Related Posts
I hope this is still a living bowl.
Leaving this here

Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.




If you have an immediate need, Power Query can be learned much quicker than Python. Go on YouTube or Udemy, then start practicing.
Bumping this - agreed
You can perform a number of mass excel tasks with Python, but you need to learn how to code in Python. Stack overflow is a good resource for this, but googling/ChatGPT will also provide solid solutions. Depends on your current knowledge of Python and libraries.
While Python can certainly work for what you want to do, it might be worth using PowerQuery instead as it's probably more accessible in the near term. Long term, Python is a great skill to have.
Definitely needs to take the time to learn python
Based on your question, you're probably best not using a python script. Just manually clean up your spreadsheet.