Hi, I have a following problem which is giving me quite a bit of manual work. So I receive often a table which is showing me amount of specimins each month in specific countries during the year. From that table I need to create another table in which the format is three columns: 1st country, 2nd specimen and 3rd month. Please see attached picture example.
caption - Copy.jpg
Is there anyway to tackle this so that I would have a formula which looks into the table on specific month / specimen and creates as many lines with the required information as stated in the column or does this require some sort of makro? Now it is all manual looking in to the table each month and copying the equivalent amount of lines to the another table. Thanks for help and comments already.
Example 1 - Copy.xlsx
Bookmarks