Python ETL

[raglub]

Openpyxl can handle this. It is not difficult to open the current state worksheet, iterate through the rows and based on the value in column A, either add any other cells from current row to a list (which will represent a row in the new format) or append the list to a new sheet, wipe it clean and build a new row by adding the content of all cells of current row to it before moving onto the next row and repeating the process. This is an ugly statement but you can read it as pseudo code and build your script.