Bls: [belajar-excel] Rumus Transpose Otomatis [1 Attachment]

Thu, 02 Feb 2017 22:04:19 -0800 

di cell A2
=INDEX(Contoh!B$5:B$15;TRUNC(ROW(1:1)/(COUNTA(Contoh!$E$3:$XFD$3)-1))+1)
copy sampai C2
copy ke bawah sampai yang diinginkan

di cell D2
=OFFSET(Contoh!$D$2;COLUMN(A:A);MOD(ROW(1:1)-1;COUNTA(Contoh!$E$3:$XFD$3))+1)
copy sampai F2
copy ke bawah sampai yang diinginkan
selanjutnya lihat di attachment sheet solusi

wassalam

Ghozi Alkatiri


--------------------------------------------
Pada Kam, 2/2/17, Modby Matsnawabi mod...@gmail.com [belajar-excel] 
<belajar-excel@yahoogroups.com> menulis:

 Judul: [belajar-excel] Rumus Transpose Otomatis [1 Attachment]
 Kepada: "belajar-excel" <belajar-excel@yahoogroups.com>
 Tanggal: Kamis, 2 Februari, 2017, 5:09 PM
 
 
  
 
 
 
   
 
 
     
       
       
       Selamat Sore,
 Para expert Excel,
 saya ada case mau transpose 500 Row
 data yang memiliki  150 colom data. klo row nya
 cuma sedikit masih sangup manual, tapi ini 500 lumayan
 gempor..contoh case saya lampirkan.
 Untuk member lain yang sudah pernah
 sharing dan sudah ada pemecahannya tolong di share
 solusinya.
 Terima
 kasih,
 salam..
 
 
     
      
 
     
     
 
 
 
 #yiv6900962383 #yiv6900962383 --
   #yiv6900962383ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv6900962383 #yiv6900962383ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv6900962383 #yiv6900962383ygrp-mkp #yiv6900962383hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv6900962383 #yiv6900962383ygrp-mkp #yiv6900962383ads {
 margin-bottom:10px;}
 
 #yiv6900962383 #yiv6900962383ygrp-mkp .yiv6900962383ad {
 padding:0 0;}
 
 #yiv6900962383 #yiv6900962383ygrp-mkp .yiv6900962383ad p {
 margin:0;}
 
 #yiv6900962383 #yiv6900962383ygrp-mkp .yiv6900962383ad a {
 color:#0000ff;text-decoration:none;}
 #yiv6900962383 #yiv6900962383ygrp-sponsor
 #yiv6900962383ygrp-lc {
 font-family:Arial;}
 
 #yiv6900962383 #yiv6900962383ygrp-sponsor
 #yiv6900962383ygrp-lc #yiv6900962383hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv6900962383 #yiv6900962383ygrp-sponsor
 #yiv6900962383ygrp-lc .yiv6900962383ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv6900962383 #yiv6900962383actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv6900962383 #yiv6900962383activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv6900962383 #yiv6900962383activity span {
 font-weight:700;}
 
 #yiv6900962383 #yiv6900962383activity span:first-child {
 text-transform:uppercase;}
 
 #yiv6900962383 #yiv6900962383activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv6900962383 #yiv6900962383activity span span {
 color:#ff7900;}
 
 #yiv6900962383 #yiv6900962383activity span
 .yiv6900962383underline {
 text-decoration:underline;}
 
 #yiv6900962383 .yiv6900962383attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv6900962383 .yiv6900962383attach div a {
 text-decoration:none;}
 
 #yiv6900962383 .yiv6900962383attach img {
 border:none;padding-right:5px;}
 
 #yiv6900962383 .yiv6900962383attach label {
 display:block;margin-bottom:5px;}
 
 #yiv6900962383 .yiv6900962383attach label a {
 text-decoration:none;}
 
 #yiv6900962383 blockquote {
 margin:0 0 0 4px;}
 
 #yiv6900962383 .yiv6900962383bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv6900962383 .yiv6900962383bold a {
 text-decoration:none;}
 
 #yiv6900962383 dd.yiv6900962383last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv6900962383 dd.yiv6900962383last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv6900962383 dd.yiv6900962383last p
 span.yiv6900962383yshortcuts {
 margin-right:0;}
 
 #yiv6900962383 div.yiv6900962383attach-table div div a {
 text-decoration:none;}
 
 #yiv6900962383 div.yiv6900962383attach-table {
 width:400px;}
 
 #yiv6900962383 div.yiv6900962383file-title a, #yiv6900962383
 div.yiv6900962383file-title a:active, #yiv6900962383
 div.yiv6900962383file-title a:hover, #yiv6900962383
 div.yiv6900962383file-title a:visited {
 text-decoration:none;}
 
 #yiv6900962383 div.yiv6900962383photo-title a,
 #yiv6900962383 div.yiv6900962383photo-title a:active,
 #yiv6900962383 div.yiv6900962383photo-title a:hover,
 #yiv6900962383 div.yiv6900962383photo-title a:visited {
 text-decoration:none;}
 
 #yiv6900962383 div#yiv6900962383ygrp-mlmsg
 #yiv6900962383ygrp-msg p a span.yiv6900962383yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv6900962383 .yiv6900962383green {
 color:#628c2a;}
 
 #yiv6900962383 .yiv6900962383MsoNormal {
 margin:0 0 0 0;}
 
 #yiv6900962383 o {
 font-size:0;}
 
 #yiv6900962383 #yiv6900962383photos div {
 float:left;width:72px;}
 
 #yiv6900962383 #yiv6900962383photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}
 
 #yiv6900962383 #yiv6900962383photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv6900962383 #yiv6900962383reco-category {
 font-size:77%;}
 
 #yiv6900962383 #yiv6900962383reco-desc {
 font-size:77%;}
 
 #yiv6900962383 .yiv6900962383replbq {
 margin:4px;}
 
 #yiv6900962383 #yiv6900962383ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv6900962383 #yiv6900962383ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv6900962383 #yiv6900962383ygrp-mlmsg table {
 font-size:inherit;font:100%;}
 
 #yiv6900962383 #yiv6900962383ygrp-mlmsg select,
 #yiv6900962383 input, #yiv6900962383 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}
 
 #yiv6900962383 #yiv6900962383ygrp-mlmsg pre, #yiv6900962383
 code {
 font:115% monospace;}
 
 #yiv6900962383 #yiv6900962383ygrp-mlmsg * {
 line-height:1.22em;}
 
 #yiv6900962383 #yiv6900962383ygrp-mlmsg #yiv6900962383logo {
 padding-bottom:10px;}
 
 
 #yiv6900962383 #yiv6900962383ygrp-msg p a {
 font-family:Verdana;}
 
 #yiv6900962383 #yiv6900962383ygrp-msg
 p#yiv6900962383attach-count span {
 color:#1E66AE;font-weight:700;}
 
 #yiv6900962383 #yiv6900962383ygrp-reco
 #yiv6900962383reco-head {
 color:#ff7900;font-weight:700;}
 
 #yiv6900962383 #yiv6900962383ygrp-reco {
 margin-bottom:20px;padding:0px;}
 
 #yiv6900962383 #yiv6900962383ygrp-sponsor #yiv6900962383ov
 li a {
 font-size:130%;text-decoration:none;}
 
 #yiv6900962383 #yiv6900962383ygrp-sponsor #yiv6900962383ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}
 
 #yiv6900962383 #yiv6900962383ygrp-sponsor #yiv6900962383ov
 ul {
 margin:0;padding:0 0 0 8px;}
 
 #yiv6900962383 #yiv6900962383ygrp-text {
 font-family:Georgia;}
 
 #yiv6900962383 #yiv6900962383ygrp-text p {
 margin:0 0 1em 0;}
 
 #yiv6900962383 #yiv6900962383ygrp-text tt {
 font-size:120%;}
 
 #yiv6900962383 #yiv6900962383ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv6900962383

Attachment: ghozi Case Excel 03022017.xlsx
Description: MS-Excel 2007 spreadsheet

  • Bls: [belajar-exc... ghozi alkatiri ghozialkat...@yahoo.co.id [belajar-excel]

Kirim email ke