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>

a	b	c	target
1		4	a,c
3	5		a,b
6			a

<thead>
</thead><tbody>
</tbody>

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;"")