Can someone please tell me how I can preserve cell formatting even after I refresh my query! This would be extremely helpful for my work project right now!
Thank you in advance.
( I have attached my file - As you can see the headers show every couple of lines which b/c those are the headers for each individual file. Even after formatting once I refresh these lines re-appear again)
I am unsure how to 'you may filter them within the query - add one more step and filter Hours (attached).'
I have deleted the 'Header Rows' within the Power Query Editor - but once I refresh the Master Key spreadsheet after the hours cells have been updated the 'Header Rows' re-appear again and the formatting of the spreadsheet returns back to the default.