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

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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?

    Edited once, last by Excel Noob: Had the column count wrong ().

  • 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!