Completed

Excel pivot table, auto text to column

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.

Skills: Excel

See more: pivot table vsto excel, excel text column, pivot table project excel, pivot table macro excel 2010, excel table pivot, create pivot table dynamically excel, excel 2007 table pivot table, excel vba column contains text column contains number, pivot excel table, net sql server table write excel pivot

About the Employer:
( 4 reviews ) Abbotsford, Australia

Project ID: #8888040

Awarded to:

surekash7096

I have the expertise in Excel and can create the pivot table based on the data imported from the text ready to start work immediately

$25 AUD in 1 day
(25 Reviews)
4.2

6 freelancers are bidding on average $23 for this job

jikrullahbd

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 More

$10 AUD in 2 days
(0 Reviews)
0.0
mildaveronika

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0
hksaleem

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0
pushparj

A proposal has not yet been provided

$25 AUD in 2 days
(0 Reviews)
0.0
ronnelblanco

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0