Occasionally I have to process data from Excel spreadsheets as part of my data warehouse work & usually these files require a bit of a…
Tag: Excel
Following on from a previous blog post on how to flatten a pivot table in Excel, this trick repeats all the labels in a flattened…
I often find that Excel files contain special characters that must be cleansed before or during processing. In the cases where the data must be…
This is another trick gleaned from exploring data to be imported to a Data Warehouse from an Excel spreadsheet. Sometimes we are provided data in…
Aim: To access hidden sheets in Excel files with protected structures using Google Sheets. In an earlier post, I described how to unhide Very Hidden…
Aim: To unhide Very Hidden Sheets in Excel. As part of a recent data warehouse project, I had to extract data from an Excel spreadsheet…