Excel pivot table, auto text to column

$10-30 AUD

Completed

Posted

over 8 years ago

$10-30 AUD

Paid on delivery

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.

Excel

Project ID: 8888040

About the project

6 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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

4.9

(25 reviews)

4.2

6 freelancers are bidding on average $23 AUD 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 Thank you

$10 AUD in 2 days