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?