Change of Excel tables

Data Processing — incorrectly specified categories?

22 USD

Client's review of cooperation with Ilya Kulpin

Change of Excel tables

22 USD

Thank you very much. Fast and quality. I’m going to talk to you, a great specialist.

5.0

Mikita Tish

Reciprocal Feedback

19 January 2021

Freelancer's review of cooperation with Mikita Tish

Change of Excel tables

22 USD

A 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.

5.0

Project translated automatically. Log in or register, to view the original In the 70 tables, it is necessary to change the order of displaying the data. Manual it will be long and incorrect, it is necessary to automatize. 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).