I have a space delimited text file which I want to be able to paste into excel in one tab and then automatically have a pivot table created on another tab, perhaps by pressing a button after doing the paste into Excel. A step in between is of course doing an automatic text to column, then creating the pivot table based on what would now be the sorted data.
I have attached:
1. A sample text file : [url removed, login to view]
2. An excel file to serve as an example of what I am trying to achieve as the end result. This file also has a tab for the description and the layout of the space delimited file.