Hi!

I have a spreadsheet with one customer per row and a large number of columns containing a variety of numbers representing the number of orders for certain parts. A large number of the columns are blank. I'm trying to create a field to summarize all orders for each customer to make it easier to see exactly which each customer has ordered without having to scroll horizontally.

Is there any way to search each row for numbers, display the numbers found followed by the respective cell column heading?

Example:

A B C D
1 Tires Oilfilters Brakepads
2 Joe Johnsson 1 0 3

In the above example I would like the cell in B2 to display 1 Tires, 3 Brakepads. Is there any way to search the row and display the found numbers with the respective column headings in this way? Thanks so much!