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 : [login to view URL]
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.
Dear Sir,
I’m expert Data Entry, Web Scrapping, Web Search and Excel and I’m very much interested in this work. I do this your job properly. Please go to my portfolio page and view my works.
Your Regards
Jikrullah
Thank you