I hope this question finds you well.
I have an excel file and there are merged headings and rows in it. I have been struggling the whole day to import this file, using transpose, unpivot, merging etc. without success. I have even tried rearranging the data but that is not feasible. I would like to get the file imported correctly so that I can filter the data for the quarters in a table and in graphs. I also want slicers to show certain columns if needed for the descriptions etc. Also want to filter per quarters.
Need to filter by Key Performance Areas, and Quarters for the various areas, like ditribution, transmissio, etc.
It seem straight forward, but with my little experience I cannot get it in the correct way.
Any help would be appreciated. File attached. Thanks!
I have an excel file and there are merged headings and rows in it. I have been struggling the whole day to import this file, using transpose, unpivot, merging etc. without success. I have even tried rearranging the data but that is not feasible. I would like to get the file imported correctly so that I can filter the data for the quarters in a table and in graphs. I also want slicers to show certain columns if needed for the descriptions etc. Also want to filter per quarters.
Need to filter by Key Performance Areas, and Quarters for the various areas, like ditribution, transmissio, etc.
It seem straight forward, but with my little experience I cannot get it in the correct way.
Any help would be appreciated. File attached. Thanks!