Dear Pak Ade,
Terimakasih atas jawabannya. Formatnya belum sesuai dg saya inginkan.
Kiranya ada alternatif lain?
Pada Selasa, 7 November 2017 10:34, "'M.Ade Alfarid' q...@kkmi.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Mungkin seperti ini?Coba gunakan format as table sebelahnya conditional
formatting Salam,Ade From: belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, November 7, 2017 9:27 AM
To: BeExcel
Subject: [belajar-excel] Merubah format report A ke B [1 Attachment]
Assalamu'alaikum Wr. Wb. Selamat Pagi dan Salam sejahtera, Mohon bantuan
rekan2 dan guru B-XLers atas kasus terlampir.Saya memiliki data dengan format
awal (Tabel 1) yg ingin diubah menjadi seperti format pada Tabel 2. Mohon
pencerahannya. Jika kasus seperti ini pernah dibahas sebelumnya, kiranya rekan2
berkenan memberikan linknya utk saya cek. Terimakasih atas perhatiannya.
Wassalam,Mulki #yiv4156463480 #yiv4156463480 -- #yiv4156463480ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv4156463480 #yiv4156463480ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv4156463480 #yiv4156463480ygrp-mkp #yiv4156463480hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4156463480 #yiv4156463480ygrp-mkp #yiv4156463480ads
{margin-bottom:10px;}#yiv4156463480 #yiv4156463480ygrp-mkp .yiv4156463480ad
{padding:0 0;}#yiv4156463480 #yiv4156463480ygrp-mkp .yiv4156463480ad p
{margin:0;}#yiv4156463480 #yiv4156463480ygrp-mkp .yiv4156463480ad a
{color:#0000ff;text-decoration:none;}#yiv4156463480 #yiv4156463480ygrp-sponsor
#yiv4156463480ygrp-lc {font-family:Arial;}#yiv4156463480
#yiv4156463480ygrp-sponsor #yiv4156463480ygrp-lc #yiv4156463480hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4156463480
#yiv4156463480ygrp-sponsor #yiv4156463480ygrp-lc .yiv4156463480ad
{margin-bottom:10px;padding:0 0;}#yiv4156463480 #yiv4156463480actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4156463480
#yiv4156463480activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4156463480
#yiv4156463480activity span {font-weight:700;}#yiv4156463480
#yiv4156463480activity span:first-child
{text-transform:uppercase;}#yiv4156463480 #yiv4156463480activity span a
{color:#5085b6;text-decoration:none;}#yiv4156463480 #yiv4156463480activity span
span {color:#ff7900;}#yiv4156463480 #yiv4156463480activity span
.yiv4156463480underline {text-decoration:underline;}#yiv4156463480
.yiv4156463480attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4156463480 .yiv4156463480attach div a
{text-decoration:none;}#yiv4156463480 .yiv4156463480attach img
{border:none;padding-right:5px;}#yiv4156463480 .yiv4156463480attach label
{display:block;margin-bottom:5px;}#yiv4156463480 .yiv4156463480attach label a
{text-decoration:none;}#yiv4156463480 blockquote {margin:0 0 0
4px;}#yiv4156463480 .yiv4156463480bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4156463480
.yiv4156463480bold a {text-decoration:none;}#yiv4156463480 dd.yiv4156463480last
p a {font-family:Verdana;font-weight:700;}#yiv4156463480 dd.yiv4156463480last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4156463480
dd.yiv4156463480last p span.yiv4156463480yshortcuts
{margin-right:0;}#yiv4156463480 div.yiv4156463480attach-table div div a
{text-decoration:none;}#yiv4156463480 div.yiv4156463480attach-table
{width:400px;}#yiv4156463480 div.yiv4156463480file-title a, #yiv4156463480
div.yiv4156463480file-title a:active, #yiv4156463480
div.yiv4156463480file-title a:hover, #yiv4156463480 div.yiv4156463480file-title
a:visited {text-decoration:none;}#yiv4156463480 div.yiv4156463480photo-title a,
#yiv4156463480 div.yiv4156463480photo-title a:active, #yiv4156463480
div.yiv4156463480photo-title a:hover, #yiv4156463480
div.yiv4156463480photo-title a:visited {text-decoration:none;}#yiv4156463480
div#yiv4156463480ygrp-mlmsg #yiv4156463480ygrp-msg p a
span.yiv4156463480yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4156463480
.yiv4156463480green {color:#628c2a;}#yiv4156463480 .yiv4156463480MsoNormal
{margin:0 0 0 0;}#yiv4156463480 o {font-size:0;}#yiv4156463480
#yiv4156463480photos div {float:left;width:72px;}#yiv4156463480
#yiv4156463480photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4156463480
#yiv4156463480photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4156463480
#yiv4156463480reco-category {font-size:77%;}#yiv4156463480
#yiv4156463480reco-desc {font-size:77%;}#yiv4156463480 .yiv4156463480replbq
{margin:4px;}#yiv4156463480 #yiv4156463480ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4156463480 #yiv4156463480ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4156463480
#yiv4156463480ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4156463480
#yiv4156463480ygrp-mlmsg select, #yiv4156463480 input, #yiv4156463480 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4156463480
#yiv4156463480ygrp-mlmsg pre, #yiv4156463480 code {font:115%
monospace;}#yiv4156463480 #yiv4156463480ygrp-mlmsg *
{line-height:1.22em;}#yiv4156463480 #yiv4156463480ygrp-mlmsg #yiv4156463480logo
{padding-bottom:10px;}#yiv4156463480 #yiv4156463480ygrp-msg p a
{font-family:Verdana;}#yiv4156463480 #yiv4156463480ygrp-msg
p#yiv4156463480attach-count span {color:#1E66AE;font-weight:700;}#yiv4156463480
#yiv4156463480ygrp-reco #yiv4156463480reco-head
{color:#ff7900;font-weight:700;}#yiv4156463480 #yiv4156463480ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4156463480 #yiv4156463480ygrp-sponsor
#yiv4156463480ov li a {font-size:130%;text-decoration:none;}#yiv4156463480
#yiv4156463480ygrp-sponsor #yiv4156463480ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4156463480
#yiv4156463480ygrp-sponsor #yiv4156463480ov ul {margin:0;padding:0 0 0
8px;}#yiv4156463480 #yiv4156463480ygrp-text
{font-family:Georgia;}#yiv4156463480 #yiv4156463480ygrp-text p {margin:0 0 1em
0;}#yiv4156463480 #yiv4156463480ygrp-text tt {font-size:120%;}#yiv4156463480
#yiv4156463480ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4156463480
