Data shaping in PowerBi

Hi guys, I used to use Alteryx in my last job as a automation tool for cleaning/reshaping data. I'm new to PowerBi and not sure if it is able to do a similar task. I extract a report from my finance system, but I need to input it in a diferent format at our internal spreadsheets. It takes me hours to re-organize all the data... I need to move cells to different areas of the spreadsheet, and also delete a good part of the data located in the report. Is there a way of automating this process with powerbi or should I try another software? 

Thanks