If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Cleaning up data with Get and Transform

Thread starter dickbuxton
Start date Jun 4, 2019
Tags

clean data financial reports get and transform powerquery sheet

dickbuxton

New Member

Jun 4, 2019

Hi, all! I have a workbook with 12 spreadsheets, one for each year’s financial statements by month. They’re all formatted as financial statements. If I use Get/Transform to clean one sheet, can I use the PowerQuery “program” from the first sheet to clean the others? Or do I have to manually use the tools on each sheet? Thanks!