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!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!