Create an Excel Power Query Solution for Appending 100 Excel Files or Tables into one Consolidated Excel Workbook

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

We have an Excel task to Combine 5 Excel WorkSheets across 100 WorkBooks that we are trying to solve with automation and the use of the Power Query Append Command. Do not respond to this project unless you can show us some actual examples of your Excel Power Query Workbooks which are working correctly.

Every 2 weeks we get between 75 and 100 individual WorkBooks named after a different person each of which contains 15 WorkSheets each with unique column headers for each WorkSheet only 5 of which are required for our consolidation process.

What we need to do is to combine the Worksheet data for everyone for every new time period into a Grand Total Universal Workbook with the 5 WorkSheets represented where each WorkSheet has ALL the data for ALL the person's in the current directory for the current period. And of course this list of person's will change for every time period, sometimes with new names and other times with 75% repeated names.

And of course, not ALL the worksheets always have exactly the same count of Column Headers across all persons for all the relevant time periods. But Power Query should handle this, correctly as I understand this.

But the Column Headers counts are usually very close each timeframe. Some of the Tabs have a dozen columns and some have perhaps 20, 30, 50 or even 175 columns in the worst case scenario. And all of these have to be handled correctly.

If we give you the sample Workbooks with only sample data for the 15 Worksheets, can you create a solution that we only have to point to a sub-directory containing the latest Workbooks every time period which will do the correct Appends into the Master Workbook for the 5 relevant Worksheet Tabs? Do not respond unless you have done this before this.

Is it possible to use the same sub-directory for the Input Workbooks hard-coded into the solution so it works with a fresh batch of Workbooks loaded into that directory for every time period going forward without any issues?

Procesamiento de datos Excel Microsoft Office

Nº del proyecto: #17867919

Sobre el proyecto

22 propuestas Proyecto remoto Activo hace 5 años

22 freelancers están ofertando un promedio de $136 por este trabajo

schoudhary1553

Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Create an Excel Power Query Solution for Appending 100 Excel Files or Tables into one Consolidated Excel Workbook. I've Más

$250 USD en 3 días
(504 comentarios)
8.4
avinav606lx

Hi there Why are you stressing on Power Query This can be done easily by using VBA scripting. Ping me to discuss more Thanks A

$166 USD en 3 días
(169 comentarios)
6.5
sevillajk01

hello! I would love to help you with your project. Just share with me your sample workbook and will see what I can do. thanks

$200 USD en 3 días
(65 comentarios)
5.4
Orientwork

I am a Data Entry/Data Processing Expert. I also have experience in word and excel. PDF to Word and Excel I know the value of time. I am very hard working and always deliver work on time

$50 USD en 3 días
(65 comentarios)
5.2
ramizq922

Hi I have read your whole description and I'm able to do that in 3 days we have excel Excel & macro VBA expert team with 7 years experience Photoshop if you can see my work please check my portfolio Thanks & Regard Más

$250 USD en 3 días
(3 comentarios)
2.2
ahmadaskar

hi, well i have done 100 + Power query projects so many of them with combine requirements but having different set of column headers "columns count" in each file !!! well this is i can call a very tough job w Más

$155 USD en 3 días
(2 comentarios)
2.1
khansajol082

Hi.. I saw your ad for an excel expert.. I want to work with you on this if you will accept my proposal. Of course I cannot convince you to but I can give an assurance of a good job from me.. Thanks.

$30 USD en 1 día
(1 comentario)
0.0
fizzahjawed

Expert Virtual Assistant (Word, Excel, PowerPoint) Hi, Hirer ! I'm Syeda.I am very excited to assist you in making your project successful. I am also flexible to all timezone . Another areas of my expertise: a) Más

$155 USD en 3 días
(0 comentarios)
0.0
Chathurakalinga1

Chathura kalinga Relevant Skills and Experience I have worked as IT officer

$155 USD en 3 días
(0 comentarios)
0.0
Lasumathi

Hire me please

$155 USD en 5 días
(0 comentarios)
0.0
mgrraj2017

Dear sir, I am very interested to do this work. If I get chance to do this I do my best. Thank You....

$111 USD en 3 días
(0 comentarios)
0.0
NtaskSolutions

I am able to do this thing within 3-5 days i have already performed this type of thing earlier where i used to create a master data from almost 100 workbooks every time it runs but only thing is that currently i am hav Más

$105 USD en 45 días
(0 comentarios)
0.0
AWong1818

Hi, I work as a pricing analyst with ten years experience in using MS Office, especially excel and word. I automate reports at work all the time using SQL, power query and DAX. I was born in Aus.

$155 USD en 3 días
(0 comentarios)
0.0
dayangamage

Hi, I can do this job for you perfectly. Please consider my offer and give me a chance.. Thanks

$30 USD en 1 día
(0 comentarios)
0.0
NgunoZ

I can complete the project in less than 3 days. Relevant Skills and Experience I have the required excel typing and pasting skills required for the project.

$111 USD en 3 días
(0 comentarios)
0.0
saykovdi

BI, Data Science, R Script, Pythone, VBA, SQL BI - Microsoft Power BI, Tableau. Data collection, processing and structuring Formation of reporting of all kinds, automation of the compilation process. Analysis of Más

$111 USD en 1 día
(0 comentarios)
0.0
Arodaniel

I have been into various Excel work even for several years, and I work mostly on Excel for various data computing.

$150 USD en 3 días
(0 comentarios)
0.0
Owais1094

If you give me a chance thats my first experience on free loncing IA you i will give my best

$155 USD en 6 días
(0 comentarios)
0.0
gracewanjiru360

excellent in Ms Excel, perfect presentation. Time conscious

$157 USD en 3 días
(0 comentarios)
0.0