[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]MATARAM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 397"]
<tbody>[TR]
[TD="class: xl65, width: 397, align: center"]'A1' => 'MATARAM',[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]BIMA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 397"]
<tbody>[TR]
[TD="class: xl65, width: 397, align: center"]'A2' => 'BIMA',[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]DOMPU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 397"]
<tbody>[TR]
[TD="class: xl65, width: 397, align: center"]?[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]PRAYA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]SELONG[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]SUMBAWA BESAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]'A6' => 'SUMBAWA BESAR'[/TD]
[/TR]
</tbody>[/TABLE]
Hello all, i need some help here,,
is that possible to make the formula on columns C3-C5 for all result ?
the pattern is to put value on column A and B to this format 'Value on column B' => 'Value on column A',
all the symbols must be shown as result value including the last comma (,)
Thanks,
Ammar
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]MATARAM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 397"]
<tbody>[TR]
[TD="class: xl65, width: 397, align: center"]'A1' => 'MATARAM',[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]BIMA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 397"]
<tbody>[TR]
[TD="class: xl65, width: 397, align: center"]'A2' => 'BIMA',[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]DOMPU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 397"]
<tbody>[TR]
[TD="class: xl65, width: 397, align: center"]?[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]PRAYA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]SELONG[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD="align: center"][TABLE="width: 155"]
<tbody>[TR]
[TD="width: 155, align: center"]SUMBAWA BESAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]A6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]'A6' => 'SUMBAWA BESAR'[/TD]
[/TR]
</tbody>[/TABLE]
Hello all, i need some help here,,
is that possible to make the formula on columns C3-C5 for all result ?
the pattern is to put value on column A and B to this format 'Value on column B' => 'Value on column A',
all the symbols must be shown as result value including the last comma (,)
Thanks,
Ammar