Hi Guys,
Facing a big problem in an excel with 90k rows. I need to change the values in the respective columns and have them in the rows with a new column header
Please help - thanks in advance.
So my data looks like this below:
Reporter Reporter Name Commodity Commodity Name Partner Units 2015 2016 2017 2018 36 Australia Gold 20319 World KG 3181015 1818669 1754690 1699184 37 Australia Gold 20319 APAC $ 8201485 7720708 7789696 11365406 38 Gold Australia 20319 EU ID 18 17 16 47
I need the table to look like this:
Year Reporter Reporter Name Commodity Commodity Name Partner Kg $ ID 2015 36 Gold Australia 20319 World 3181015 8201485 18 2016 36 Gold Australia 20319 World 1818669 7720708 17
and so on...
Please Help!!
Bookmarks