Hello,
I am looking for a way to merge two fields into one in a pivot table. I will explain my problem with an example.
The material of which a certain thing is made is in this example has to be put in a pivot table. Some things are made of different materials, which are currently present in two different columns of the data.
1. Wood
2. Wood
3. Plastic
4. Metal
5. Metal Wood
6. Plastic
7. Plastic Metal
8. Wood
etc.
The Pivot table should look like this:
Metal 3
Wood 4
Plastic 3
To make things more difficult, it is also possible to change the y-axis, for example from material to shape. I already did this using a macro which can be found in this video: youtube.com/watch?v=vLISpSGKhlQ
I hope I made it clear, if not I'll try to explain it a bit better.
Thank you in advance!
Bookmarks