Hi. This is my first post. I have MANY spreadsheets that have been formatted for print and I am working to combine and automate these files for easy retrieval and EDA. The files are formatted like this:
I have a process to get to the data in the format that I want, but it is clunky and cumbersome. In short, I clean the data to a point where I have two new queries (one for each "Cost Center" Column) and then I append them as a new query to achieve the table below... Is there a better/faster way to get here??? Thanks!
I have a process to get to the data in the format that I want, but it is clunky and cumbersome. In short, I clean the data to a point where I have two new queries (one for each "Cost Center" Column) and then I append them as a new query to achieve the table below... Is there a better/faster way to get here??? Thanks!