Yandeez
Member
Hi -
I have attached data that is imported into excel from Qlikview. I'd like to get this data into a Pivot Table friendly format so that I can use the PT for some data analysis (YoY, month by month) etc. Sheet 2 contains column headers that I'm looking for. This tab will be the sourcedata for the PT. Is there a macro I can run every time so that when I import the data in this ugly format, I can run the macro and then create my PT? Any help would be immensely helpful. All data has been changed.
I have attached data that is imported into excel from Qlikview. I'd like to get this data into a Pivot Table friendly format so that I can use the PT for some data analysis (YoY, month by month) etc. Sheet 2 contains column headers that I'm looking for. This tab will be the sourcedata for the PT. Is there a macro I can run every time so that when I import the data in this ugly format, I can run the macro and then create my PT? Any help would be immensely helpful. All data has been changed.