Dear user,
After doing calculations with pivot tables, I have a large set of data that I have to convert to a specific format.
The pivot table looks exactly the same as the picture:
two-dimensional-pivot-table.png
What I want to achieve is:
- For every specific Fruit in column B to H;
- I want to repeat the country and put the specific fruit in column B;
- AND the value of the fruit in column C;
The end result has to look like this:
Australia - Apple - 20634
Australia - Banana - 52721
Australia - Beans - 14433
...
Ofcourse I can do this manually, but my dataset is too large for it.
Does anyone know how to do this automatically?
Bookmarks