Change of Excel tables
25 USDYou 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).
В 70 таблицах необходимо изменить порядок отображения данных. Вручную это будет долго и неточно, необходимо автоматизировать.
Необходимо сделать подобно для всех файлов:
Столбец A - Country Name – названия стран по алфавиту сверху вниз (без повторов, каждая позиция 1 раз)
Столбцы от B и далее – года от наименьшего к наибольшему слева направо
На пересечении даты и страны – значения в данном году
В таблицах, где данные заканчиваются в одном столбце в текущем году, а затем появляются прогнозы со следующего года – объединить данные в 1 столбец (например, документ population-of-all-world-regions-including-the-un-projection-until-2100). Не складывать значения, а переместить просто в один столбец.
Коды стран можно удалить.
В качестве примеров прикрепил образец одной таблицы Как сейчас (на страну по 50 строк) и Как надо (одна страна - одна строка по годам).
Applications 2
Client's feedback on 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 feedback on 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.
-
Hello to you.
Ready to implement your project.
Write it. I will be happy to cooperate.
Здравствуйте.
Готова выполнить Ваш проект.
Пишите. Буду рада сотрудничеству.
-
Good day . Interested in your project. Ready to discuss and implement.
Добрый день. Заинтересован вашим проектом. Готов обсудить и выполнить.
-
992 29 1 Good day . I will make the tables you need. Excel and macros are well known.
Добрый день. Сделаю нужные Вам правки таблиц. С экселем и макросами знаком отлично
-
438 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.
Добрый день! Использую собственные наборы макросов для автоматизации. Бюджет и примерный срок указал. В среднем по 50 грн. за таблицу.
Current freelance projects in the category Data processing
Process Excel price list (Manual check)There is an Excel price list with 13633 items. Each item has color characteristics, usually one, sometimes two or three. Currently, there are approximately 500 color names in this file that need to be simplified as much as possible by replacing values. For example: 1) There is a… Content management, Data processing ∙ 6 proposals |
[TM] BA Analyst - create 30 SQL queries for dataset
120 USD
Good day, there is a dataset consisting of 3 tables, need to create 30 SQL queries for it. Domain - ecommerce 5 simple queries for each table 2 complex queries with aggregations for each table 4 queries for table pairs with aggregation 5 queries for all tables at once I need… Databases, Data processing ∙ 5 proposals |
Automation needs to be done on make com (GPT + TG + Notion)Hello everyone, some automation needs to be done: 1. send a json file with the task to telegram (the file will have the same keys in json format) 2. Process the json in make com 3. Create the corresponding task in the respective teamspace in Notion Who has experience and… Machine learning, Data processing ∙ 1 proposal |
Data table formatting and RFM analysis1. The CRM table of all customer orders has been exported. It needs to be formatted in such a way that it becomes convenient for reading and working. The following columns should be included: customer (full name), phone number, total number of orders, date of the last order,… Databases, Data processing ∙ 6 proposals |
Adapt the company's price for uploading to Key CRMProject goal: Automation and optimization of inventory management process by transferring data from existing accounting software to Customer Relationship Management (CRM) system "KeyCRM". - Deadline: 1 day - Data source: Dntrade around - Target system: CRM system "KeyCRM". -… Data processing, Client management and CRM ∙ 2 proposals |