Combine Column + Columns Header Data, Skipping Cells with no Value

[alex0182828]

<style>table { }.font5 { color: black; font-size: 9pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; }.font6 { color: black; font-size: 9pt; font-weight: 700; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; }.font7 { color: black; font-size: 9pt; font-weight: 700; font-style: normal; text-decoration: none; font-family: Tahoma,sans-serif; }.font8 { color: black; font-size: 9pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Tahoma,sans-serif; }td { padding: 0px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl67 { color: windowtext; }.xl68 { color: windowtext; font-weight: 700; }.xl69 { color: black; }.xl70 { color: black; }.xl71 { color: black; }.xl72 { color: black; }.xl73 { color: black; font-weight: 700; }.xl74 { color: black; font-weight: 700; background: rgb(162, 189, 144) none repeat scroll 0% 0%; }.xl75 { color: black; background: rgb(51, 204, 204) none repeat scroll 0% 0%; }.xl76 { color: black; background: rgb(51, 204, 204) none repeat scroll 0% 0%; }.xl77 { color: black; background: rgb(51, 204, 204) none repeat scroll 0% 0%; }.xl78 { color: black; font-weight: 700; }.xl79 { color: black; border-width: 0.5pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; }</style>

The example below give a good idea i need help on a formula to populate the 'Full String' Column like : "coloumnheader:rowvalue^columnheader:rowvalue" Skipping any columns where the value is N/A. There are about 15 potential columns to combine. Thanks in Advance. Alex <tbody> </tbody> <tbody> </tbody> Type Metal Material Recipient Full String Cake Gold N/A Her Type:Earrings^Metal:Gold^Recipient:Her Sandwhich Silver Pure N/A Type:Sandwhich^Metal:Silver^Material:Pure <tbody> </tbody>

<tbody>
</tbody>

<tbody>
</tbody>

 

[shobolos]

=$A$1&":"&A2&"^"&IF(D2="n/a","",INDEX($B$1:$D$1,MATCH(D2,$B2:$D2,0))&":"&D2)&"^"&IF(C2="n/a","",INDEX($B$1:$D$1,MATCH(C2,$B2:$D2,0))&":"&C2)&"^"&IF(B2="n/a","",INDEX($B$1:$D$1,MATCH(B2,$B2:$D2,0))&":"&B2)

 

[alex0182828]

Hello Shobolos,

Thats works like a treat

Thanks. A