Check Row for data in column and return value and heading for each column containing a value

Hi,

I have a large spreadsheet that contains customer information in each row. There are more than 500 columns to the right that contain part numbers and descriptions in the top row. I need to be able to look at a row and return some customer data such as customer name currently contained in A2 and store number in A3 along with every column in that row that contains a numerical value from column AD on and it's associated column title contained in AD1 and on respectfully.

I attempted to use a pivot table but it's just too unwieldy as it shows everything even if it's blank. I just want to show the columns that have a value in them.

Not sure this is even possible. Any suggestions?

Hi Pecoflyer,

Thank you for the reply. I ended up using a couple of different pivot tables and then used a formula to reference the information I needed. I was on deadline so I just had to get down and dirty to get it done. Thank you for your interest in this though. Cheers!