En curso

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.

Habilidades: Excel

Ver más: 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

Información del empleador:
( 4 comentarios ) Abbotsford, Australia

ID de proyecto: #8888040

Adjudicado a:

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 en 1 día
(25 comentarios)
4.2

6 los freelancers están ofertando un promedio de $23 para este trabajo.

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 Más

$10 AUD en 2 días
(0 comentarios)
0.0
mildaveronika

A proposal has not yet been provided

$25 AUD en 1 día
(0 comentarios)
0.0
hksaleem

A proposal has not yet been provided

$25 AUD en 1 día
(0 comentarios)
0.0
pushparj

A proposal has not yet been provided

$25 AUD en 2 días
(0 comentarios)
0.0
ronnelblanco

A proposal has not yet been provided

$25 AUD en 1 día
(0 comentarios)
0.0