• Projects -
  • Rating -
  • Rating 310

Budget: 5000 UAH Deadline: 5 days

Good day !To bring a constantly changing file structure to a single nominer with Power Query will not succeed!This tool allows you to step-by-step go through the data and process them, releasing you from the routine.If the data structure regularly appears new information (stack, text value in the cell with a number), then this will lead to an error in the work of the Power Query algorithm and it will need to be constantly rewrite (continually search for the error and rewrite), also partially refer to the macros.The information in your source files is not intended to be processed with Power Query, it is most likely to be structured so that it is easy to print, and with the same success it could be provided in word or pdf.If the task is to track the price changes, then I recommend you to create your database and transfer information from the sources to it.The structure of this base can be as follows:

Category

Childhood - Childhood "Savana" - Style written - 1527
Childhood - Childhood "Savana" - Nadbudova - 1280
Child - Child "Savana" - Tumba - 1377

And so on... In this case you will be able to use the filter on the field the finished product and see its composite, transfer new data there in this case will come into the manual.If the data is transferred from a database to the source Excel, then you need to provide the database source or part of it so that you can understand whether it is suitable for processing in Power Query.

  • Projects 13
  • Rating -
  • Rating 419

Budget: 1000 UAH Deadline: 1 day

Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.

Current freelance projects in the category Databases & SQL

9:31
9 July
7 July
7 July
6 July