Return Column Names AND values from row in a reference column
I'm trying to figure out how to return the columns and values found in them for any given row.
I have approximately 200 unique columns that are populated from a web form if/when the column is relevant.
individual rows track construction items completed. Each row identifies crew, date, job number, etc., and the remaining columns are the construction billing units that may or may not be claimed for that day's work.
What I would like to generate is a summary of individual values from all non-blank cells in a given row that include their respective column names (which are the billing item names) as a prefix to to the value entered.
Currently, when using Join / Collect the result is an indecipherable grouping of numerical quantities without context.