Change of Excel tables
You need to do the same for all files:
A - Country Name - countries names by the alphabet from above down (without repetitions, each position 1 time)
Columns from B and later - the year from the smallest to the greatest left to the right
On the crossing of date and country - values in this year
In the tables where the data ends in one column in the current year, and then the forecasts from the next year appear - combine the data in 1 column (e.g., the document population-of-all-world-regions-including-the-un-projection-until-2100). Do not put the values, but just move into one column.
Country codes can be removed.
As examples attached a sample of one table How Now (on a country by 50 lines) and How Should (one country - one line by years).
Applications 2
Client's review of cooperation with Ilya Kulpin
Change of Excel tablesThank you very much. Fast and quality. I’m going to talk to you, a great specialist.
Freelancer's review of cooperation with Mikita Tish
Change of Excel tablesA good customer. We do not work for the first time. He knows clearly what he wants. Always in contact, you will explain what you need. pleasant in communication. Thank you for cooperation.
-
746 29 1 Good day . I will make the tables you need. Excel and macros are well known.
-
2629 227 0 Hello to you.
Ready to implement your project.
Write it. I will be happy to cooperate.
-
8235 381 0 1 Good day . Interested in your project. Ready to discuss and implement.
-
312 5 0 Good day ! I use my own macro set for automation. The budget and the example period indicated. Average of 50 UAH. for the table.
Current freelance projects in the category Data Processing
Research AssistantWe are looking for a student or high school pupil who can find information on the internet and structure it neatly. What to do: - Search for necessary data on Instagram, TikTok, YouTube, Google, and other open sources - Enter results into Google Sheets, Google Docs What is… Data Processing, Information Gathering ∙ 13 hours 15 minutes back ∙ 9 proposals |
Adjustment of applications in CRM SalesDrive — one-time job for today (6–7 hours)
67 USD
A careful performer is needed for one-time work today. The task is to adjust applications in our CRM system (SalesDrive) according to the provided instructions: separate applications, process fiscal receipts, and write a comment for the application. Data Processing ∙ 2 days 15 hours back ∙ 22 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 5 days 19 hours back ∙ 19 proposals |
Analytics Setup
223 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 6 days 13 hours back ∙ 18 proposals |
Integration of HubSpot with lead generation sources (Perspective, WordPress, Meta Ads)
89 USD
Good day! Project goal: To build end-to-end automation for lead collection from a multi-platform ecosystem into HubSpot CRM. It is necessary to ensure the creation/updating of contacts and the automatic opening of deals while preserving the full attribution chain of traffic… Content Management Systems, Data Processing ∙ 8 days 2 hours back ∙ 18 proposals |