C
Cecil
I have a worksheet of rows of customers and columns of products. There
are about 250 customers and about 100 products. Therefore, there are
25,000 cells of data. Each cell contains the dollar amount of that
product sold to that customer. I would like to create a 3-column list
of data that contains customer-name, product-name and dollars sold.
The number of rows in that list would equal the number of cells that
are non-zero. In other words, cells with zero dollars can be ignored.
How can this be accomplished?
are about 250 customers and about 100 products. Therefore, there are
25,000 cells of data. Each cell contains the dollar amount of that
product sold to that customer. I would like to create a 3-column list
of data that contains customer-name, product-name and dollars sold.
The number of rows in that list would equal the number of cells that
are non-zero. In other words, cells with zero dollars can be ignored.
How can this be accomplished?