Power Query and Excel
15 USD In the second case, it should be further described the exclusive grouping that if the column "Code 1" is 9999 or 7676, then it should be broken by: Name and surname, Code 1, Code 2, Code 3 (not that from code 3 we don't want to see transactions with code 7788) and ID.
The price is agreed.
You can use the formulas or Power Query. The file is covered.
Я змінив файл, надіюсь так краще буде і добавив два описи завдання в стрічці 11 та 12
Applications 1
-
1 day15 USD
335 1 0 1 day15 USD
Welcome to Alexandra!
Data grouping can be performed in Power Query by connecting to a data page and obtaining a grouping result on another page. In fact, you will get a functional design for further use.
Based on the data, the task is clear.
-
1 day15 USD
1115 109 0 1 day15 USD
Hello to you.
I write a macro VBA. Write in ls, you need to see a full file with data or just a bigger volume that 5m is in the example.
-
1 day16 USD
4467 102 0 1 day16 USD
Good day . I will be glad to help. Can I look at the file?
-
1 day15 USD
421 13 0 1 day15 USD
Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
2 days45 USD
250 37 1 2 2 days45 USD
Really you need to clearly describe the grouping algorithm, the task can be realised
-
1 day15 USD
5940 345 0 1 day15 USD
I can help create a macro for Excel that will make grouping.
But the grouping algorithm itself is not very understood, it is necessary to discuss.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 2 days 5 hours back ∙ 4 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 2 days 8 hours back ∙ 18 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 4 days back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 5 days 5 hours back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 5 days 8 hours back ∙ 13 proposals |
Ukraine