Each week I get an csv file that has many sections of data in one sheet. In general I would like to be able to grab these sections and have them live separately.
On my attachment you can see my "current" data set I receive. They have a similar set up, but the different sections can have varying amount of rows week to week. There is always a blank row separating the sections. I thought (looking at the "need" section) that maybe if I could take the headers from each section and turn them into columns I could make that work. But I'm stuck. Thought maybe something with the Multi-Row Formula tool could work, but I am not very familiar with the tool enough to really try to get it to work.
Is this even possible?
