Conditional Concatenation If Cell Contains Data, Concatenate, Else, Move to Next Cell

[jrdrcs]

Scenario: 30 Columns and 2000 rows with data. Any given row may have data in as few as two columns or as many as 20 columns. My challenge: Concatentate only the cells with data and insert a line feed between each concatenation within the results.

1. Skip cells where no data is present
2. If data is present, Concatenate the column Header, then the data in the cell
3. Move on to the next cell and repeat steps 1 & 2...WITH ONE EXCEPTION...
4. Between each instance of concatenation, INSERT a Line Feed AKA: Carriage Return or ALT Enter

See Attached...much nicer to look at than this crude representation of three rows of representative data and desired results below:

Color: Material: Handle Type: Size: Length: Width: Height: Weight in Pounds: Guarantee:

Steel Grip 8"
Blue Wood Large

Red 4" 14" 3" 3 1 Year


Material: Steel
Handle Type: Grip
Length: 8"

Color: Blue
Material: Wood
Size: Large

Color: Red
Length: 4"
Width: 14"
Height: 3"
Weight in Pounds: 3
Guarantee: 1 Year