Forum Discussion
Returning the column name for only the filled cells
Hi everyone, I have the following example data set. The complete data set is rather large and picking out manually would be time consuming and inefficient. I would like to know which numbers (Pa...
When you say to be dealing with a "rather large" data set, consider using Power Query. Then you can fairly easily flatten the data (i.e. unpivot) and than group by Part Description. It's flexible, easy to maintain, though it requires a Refresh when the underlying data changes.
An example is attached.