Creating a working controllable PIVOT Table based on an Excel file
There is a flat Excel spreadsheet with multiple tabs. From it, a manageable PIVOT table needs to be created. The work involves immersing in the topic and exchanging questions and answers to arrive at an acceptable and appropriate structure. The decision on collaboration is initially made based on the analysis of experience and qualifications, and then based on the assessment of the file.
Experience working with EUROMONITOR databases is highly desirable
Очень желателен опыт работы с базами ЕВРОМОНИТОР
Client's review of cooperation with Oleksandra Butenko
Creating a working controllable PIVOT Table based on an Excel fileEverything went very well. Good job, pleasant communication. Everything on time. I recommend for collaboration.
Freelancer's review of cooperation with Yaroslav Koval
Creating a working controllable PIVOT Table based on an Excel fileI recommend for collaboration. Regular communication, constant feedback
-
4461 102 0 Good afternoon. I would be happy to help. But I need to look at the data to estimate the cost and time for completion.
-
656 9 0 Good evening, Yaroslav!
The overall task is clear, but to provide an accurate response regarding deadlines and price, I would like to clarify some questions that arose after analyzing your task.
Please write in private messages — we will discuss the details and your wishes.
-
2327 61 0 Hello!
I have extensive experience working with Excel/PowerQuery/PowerBI/SQL. I will build a "readable" table from the most "unreadable" parts :)
The price depends on the complexity of the table; initially, it would be good to familiarize myself with the file.
-
1026 15 0 Good day.
I have extensive experience working with Excel, especially with Power Query and Power Pivot. I am ready to discuss the task in more detail.
-
986 12 1 Analyst with over 15 years of experience in the commodity market, particularly in the distribution of tobacco products. Specializes in building reports in Excel using:
- Pivot Tables
- Dynamic charts
- Slicers for interactive control
- Formulas in pivot tables for advanced analysis
What I offer
Based on your Excel file with multiple tabs, I:
- Consolidate data into a single flat table
… - Build a pivot table with filters and aggregation
- Add slicers for convenient report management
- Set up basic interactivity
Work stages
- Analyze the structure of the tabs
- Combine data (manually or via macro)
- Create Pivot Table
- Add slicers
- Check and coordinate
Additionally
- Possibility to expand functionality (charts, automation, macros)
-
2578 57 1 1 I work as a financial analyst in a large international company. 10 years of experience with spreadsheets. I will help. The price is currently minimal, need to see the volume of work
-
988 30 0 Good day. I have extensive experience working with Excel and Google Sheets. I have experience creating tables for various requests and requirements. I will help create the necessary tables. Write in private messages, we will discuss everything.
-
307 I have been developing spreadsheets for businesses for 8 years.
Among them:
- accounting;
- CRM system;
- data aggregation into statistics;
- calculators;
- data entry systems (for accounting/warehouse CRM, etc.);
- data transfer between different employee roles within the company.
Google Drive
…Google Drive
Google Drive
-
567 28 2 Merging data from tabs into a summary table is not a problem. You need to look at the source, it can be with fake data. And understand what you want to get as a result. Write, let's discuss.
-
Ярослав, имеете в виду сводную таблицу? Или нужно сделать лист с формулами, которые вытягивают и анализируют данные в других листах?
-
Current freelance projects in the category Databases & SQL
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 1 day 23 hours back ∙ 15 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 3 days 23 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 4 days 10 hours back ∙ 5 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 7 days 17 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
603 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 9 days 21 hours back ∙ 61 proposals |