Hello everyone,
I'm looking for a VBA code that allows me to convert a matrix of 10 columns and undefined number of rows to a 4 column list.
the first column are my customers, the second are my products and my first row are the 8 different packages we have. The matrix shows which volume a certain customer would want to buy from a certain product in a certain package. So I will receive input from arround 30 customers telling me which of the 300 products they want to buy in which package.
I would just need a VBA code to convert this matrix to a list, so I can run a Pivot Table on it. It can be that there are empty cells in this matrix, they don't have to be included in the list.
I use Excell 2010.
The matrix is located in a seperate sheet ("Master data") and the list should be shown in another sheet ("Tidy Data")
To give you an idea how the matrix looks like:
Package 1 Package 2 Package 3 Package 4 Package 5 Package 6 Package 7 Package 8
Customer A Product A
Customer A Product B
Customer A Product C
Customer A Product ...
Customer B Product A
Customer B Product B
Customer B Product C
Customer B Product ...
...
I hope someone can help me!
Thanks,
Nick
I just found the solution.
Below you can find the code
Please Login or Register to view this content.
Bookmarks