Pull Data Based On Header

[muhammad susanto]

hi all..

how to get data based on header and joint them
my target that cell contains data
here this below :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]a[/TH]
[TH]b[/TH]
[TH]c[/TH]
[TH]target[/TH]
[/TR]
</thead><tbody> [TR]
[TD]1[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]a,c[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]a,b[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]a[/TD]
[/TR]
</tbody>[/TABLE]


any help me, thanks in advance

.sst

 

[Fazza]

what about, in cell D2 and drag down
=$A$1&IF(LEN(B2)>0,","&$B$1,"")&IF(LEN(C2)>0,","&$C$1,"")

 

[muhammad susanto]

hi..
i have testing it but it's not working well...someone could help me out.

 

[Fazza]

Selamat. what is the problem?

 

[mohadin]

Hi
Fazz formula is Ok but maybe

=$A$1&IF(LEN(B2)>0;","&$B$1;"")&IF(LEN(C2)>0;","&$C$1;"")