Transposing Data Macro (flip columns)

Hello all,

Was just trying to transpose data from the following format:

1990 1991 1992
Argentina 142392 158738 181927
Armenia 20426 22497 21449
Australia 1093826 1125405 1150691

into:

1990 Argentina 142392
1991 Argentina 158738
1992 Argentina 181927
1990 Armenia 20426
1991 Armenia 22497
1992 Armenia 21449
1990 Australia 1093826
1991 Australia 1125405
1992 Australia 1150691

I managed to find a macro on this forum titled excelflip but for some reason it did not save on my excel file and now I can't seem to be able to find it. I know that this has been answered somewhere on this forum. If someone could provide me with this macro or a link to the thread, I would very much appreciate it.

Thanks.

Hi nilem,

Thank you for the fast reply, but as I am a newbie to Excel and macros, would you be able to forward me the macro as a file, as I do not know how to implement it an excel file. Will this work for 100 countries?

Thanks,
Nick

EDITED: With a bit of research I figured it out, thanks for your help! I very much appreciate it!