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?


--
Cecil
------------------------------------------------------------------------
Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035
View this thread: http://www.excelforum.com/showthread...hreadid=563926

Would a VBA code solution be something you could use?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Cecil"
wrote in message 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?
--
Cecil