Cleaning Excel Data Question

[agd50]

Any advice for cleaning Excel data that doesn't translate well for Power BI? 

(Lots of colored cells, Subheaders that are hard to edit, etc) 
Flat vs Wide perhaps? TIA

[Ritaf1983 · Accepted solution]

Hi @agd50 
Most of the cleaning manipulations are possible with the power query itself, take a look at the linked guide:
https://www.youtube.com/watch?v=AWcmiyra7qs

Other ETL tools that you can use: excel, pandas, data factory etc...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly