Kalau pake formula "ribet", mungkin pake macro lebih "pas" pelaksanaannya namun lebih ribet bikin prgnya.File terlampir. Salam,HK
From: "'Mr. Kid' [email protected] [belajar-excel]"
<[email protected]>
To: BeExcel <[email protected]>
Sent: Friday, 20 February 2015, 14:17
Subject: Re: [belajar-excel] Re: Cara Copy Paste Tranpose (tapi bukan tranpose)
hmmm....
kalau begitu, bisa pakai kolom bantu tuh...
postingan Pak HK sebelum ini sudah ada kan yang pakai kolom bantu.
File terlampir sekedar variasi tentang si kolom bantu. Sebenarnya bisa juga
tanpa kolom bantu sih, cuma agak bingung njelasinnya karena ada syaratnya. Sila
lihat file terlampir saja ya.
Wassalam,
Kid.
2015-02-20 15:19 GMT+11:00 [email protected] [belajar-excel]
<[email protected]>:
Matur suwun sanget kagem solusinya..
Tapi ada masalah ternyata.. di data2 bawah tidak semua samap persis isiannya..
ada baris NIK atau Status atau ada juga yang lain yang tidak ada..
Jika di aplikasikan rumus tsb jadinya bagian yang tidak ada tidak terhitung..
Pengennya untuk baris yang tidak ada nantinya di kolomnya akan kosong...
Tolong masukkannya..
Terimakasih
Wassalam ^__^
#yiv2902824353 #yiv2902824353 -- #yiv2902824353ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2902824353
#yiv2902824353ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2902824353
#yiv2902824353ygrp-mkp #yiv2902824353hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2902824353 #yiv2902824353ygrp-mkp #yiv2902824353ads
{margin-bottom:10px;}#yiv2902824353 #yiv2902824353ygrp-mkp .yiv2902824353ad
{padding:0 0;}#yiv2902824353 #yiv2902824353ygrp-mkp .yiv2902824353ad p
{margin:0;}#yiv2902824353 #yiv2902824353ygrp-mkp .yiv2902824353ad a
{color:#0000ff;text-decoration:none;}#yiv2902824353 #yiv2902824353ygrp-sponsor
#yiv2902824353ygrp-lc {font-family:Arial;}#yiv2902824353
#yiv2902824353ygrp-sponsor #yiv2902824353ygrp-lc #yiv2902824353hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2902824353
#yiv2902824353ygrp-sponsor #yiv2902824353ygrp-lc .yiv2902824353ad
{margin-bottom:10px;padding:0 0;}#yiv2902824353 #yiv2902824353actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2902824353
#yiv2902824353activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2902824353
#yiv2902824353activity span {font-weight:700;}#yiv2902824353
#yiv2902824353activity span:first-child
{text-transform:uppercase;}#yiv2902824353 #yiv2902824353activity span a
{color:#5085b6;text-decoration:none;}#yiv2902824353 #yiv2902824353activity span
span {color:#ff7900;}#yiv2902824353 #yiv2902824353activity span
.yiv2902824353underline {text-decoration:underline;}#yiv2902824353
.yiv2902824353attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2902824353 .yiv2902824353attach div a
{text-decoration:none;}#yiv2902824353 .yiv2902824353attach img
{border:none;padding-right:5px;}#yiv2902824353 .yiv2902824353attach label
{display:block;margin-bottom:5px;}#yiv2902824353 .yiv2902824353attach label a
{text-decoration:none;}#yiv2902824353 blockquote {margin:0 0 0
4px;}#yiv2902824353 .yiv2902824353bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2902824353
.yiv2902824353bold a {text-decoration:none;}#yiv2902824353 dd.yiv2902824353last
p a {font-family:Verdana;font-weight:700;}#yiv2902824353 dd.yiv2902824353last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2902824353
dd.yiv2902824353last p span.yiv2902824353yshortcuts
{margin-right:0;}#yiv2902824353 div.yiv2902824353attach-table div div a
{text-decoration:none;}#yiv2902824353 div.yiv2902824353attach-table
{width:400px;}#yiv2902824353 div.yiv2902824353file-title a, #yiv2902824353
div.yiv2902824353file-title a:active, #yiv2902824353
div.yiv2902824353file-title a:hover, #yiv2902824353 div.yiv2902824353file-title
a:visited {text-decoration:none;}#yiv2902824353 div.yiv2902824353photo-title a,
#yiv2902824353 div.yiv2902824353photo-title a:active, #yiv2902824353
div.yiv2902824353photo-title a:hover, #yiv2902824353
div.yiv2902824353photo-title a:visited {text-decoration:none;}#yiv2902824353
div#yiv2902824353ygrp-mlmsg #yiv2902824353ygrp-msg p a
span.yiv2902824353yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2902824353
.yiv2902824353green {color:#628c2a;}#yiv2902824353 .yiv2902824353MsoNormal
{margin:0 0 0 0;}#yiv2902824353 o {font-size:0;}#yiv2902824353
#yiv2902824353photos div {float:left;width:72px;}#yiv2902824353
#yiv2902824353photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2902824353
#yiv2902824353photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2902824353
#yiv2902824353reco-category {font-size:77%;}#yiv2902824353
#yiv2902824353reco-desc {font-size:77%;}#yiv2902824353 .yiv2902824353replbq
{margin:4px;}#yiv2902824353 #yiv2902824353ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2902824353 #yiv2902824353ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2902824353
#yiv2902824353ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2902824353
#yiv2902824353ygrp-mlmsg select, #yiv2902824353 input, #yiv2902824353 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2902824353
#yiv2902824353ygrp-mlmsg pre, #yiv2902824353 code {font:115%
monospace;}#yiv2902824353 #yiv2902824353ygrp-mlmsg *
{line-height:1.22em;}#yiv2902824353 #yiv2902824353ygrp-mlmsg #yiv2902824353logo
{padding-bottom:10px;}#yiv2902824353 #yiv2902824353ygrp-msg p a
{font-family:Verdana;}#yiv2902824353 #yiv2902824353ygrp-msg
p#yiv2902824353attach-count span {color:#1E66AE;font-weight:700;}#yiv2902824353
#yiv2902824353ygrp-reco #yiv2902824353reco-head
{color:#ff7900;font-weight:700;}#yiv2902824353 #yiv2902824353ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2902824353 #yiv2902824353ygrp-sponsor
#yiv2902824353ov li a {font-size:130%;text-decoration:none;}#yiv2902824353
#yiv2902824353ygrp-sponsor #yiv2902824353ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2902824353
#yiv2902824353ygrp-sponsor #yiv2902824353ov ul {margin:0;padding:0 0 0
8px;}#yiv2902824353 #yiv2902824353ygrp-text
{font-family:Georgia;}#yiv2902824353 #yiv2902824353ygrp-text p {margin:0 0 1em
0;}#yiv2902824353 #yiv2902824353ygrp-text tt {font-size:120%;}#yiv2902824353
#yiv2902824353ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2902824353
re_cara transpose (pake macro).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
