Hai Misi,Untuk mempersingkat formula diperlukan kolom bantu yang menggabungkan No Urut (diisi penuh) dengan Judul (Nama,TTL,NIK,Alamat,Status,Pekerjaan).Kemudian gunakan gabungan Fungsi Index dan Match.Hasilnya seperti file terlampir. Salam,HK
From: "[email protected] [belajar-excel]" <[email protected]>
To: [email protected]
Sent: Wednesday, 18 February 2015, 23:51
Subject: [belajar-excel] Cara Copy Paste Tranpose (tapi bukan tranpose) [1
Attachment]
Misi.. Ingin bertanya lagi..
Ini sya pengen copas tranpose data biodata yang bentuknya 2 kolom menjadi
beberapa kolom sesuai dengan isiannya..
Contoh terlampir
Klo macam kasus ini namanya apa ya? pahamnya cuman tranpose :)
terima kasih sbelumnya :) #yiv4297798800 #yiv4297798800 --
#yiv4297798800ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv4297798800 #yiv4297798800ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv4297798800 #yiv4297798800ygrp-mkp #yiv4297798800hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4297798800 #yiv4297798800ygrp-mkp #yiv4297798800ads
{margin-bottom:10px;}#yiv4297798800 #yiv4297798800ygrp-mkp .yiv4297798800ad
{padding:0 0;}#yiv4297798800 #yiv4297798800ygrp-mkp .yiv4297798800ad p
{margin:0;}#yiv4297798800 #yiv4297798800ygrp-mkp .yiv4297798800ad a
{color:#0000ff;text-decoration:none;}#yiv4297798800 #yiv4297798800ygrp-sponsor
#yiv4297798800ygrp-lc {font-family:Arial;}#yiv4297798800
#yiv4297798800ygrp-sponsor #yiv4297798800ygrp-lc #yiv4297798800hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4297798800
#yiv4297798800ygrp-sponsor #yiv4297798800ygrp-lc .yiv4297798800ad
{margin-bottom:10px;padding:0 0;}#yiv4297798800 #yiv4297798800actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4297798800
#yiv4297798800activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4297798800
#yiv4297798800activity span {font-weight:700;}#yiv4297798800
#yiv4297798800activity span:first-child
{text-transform:uppercase;}#yiv4297798800 #yiv4297798800activity span a
{color:#5085b6;text-decoration:none;}#yiv4297798800 #yiv4297798800activity span
span {color:#ff7900;}#yiv4297798800 #yiv4297798800activity span
.yiv4297798800underline {text-decoration:underline;}#yiv4297798800
.yiv4297798800attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4297798800 .yiv4297798800attach div a
{text-decoration:none;}#yiv4297798800 .yiv4297798800attach img
{border:none;padding-right:5px;}#yiv4297798800 .yiv4297798800attach label
{display:block;margin-bottom:5px;}#yiv4297798800 .yiv4297798800attach label a
{text-decoration:none;}#yiv4297798800 blockquote {margin:0 0 0
4px;}#yiv4297798800 .yiv4297798800bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4297798800
.yiv4297798800bold a {text-decoration:none;}#yiv4297798800 dd.yiv4297798800last
p a {font-family:Verdana;font-weight:700;}#yiv4297798800 dd.yiv4297798800last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4297798800
dd.yiv4297798800last p span.yiv4297798800yshortcuts
{margin-right:0;}#yiv4297798800 div.yiv4297798800attach-table div div a
{text-decoration:none;}#yiv4297798800 div.yiv4297798800attach-table
{width:400px;}#yiv4297798800 div.yiv4297798800file-title a, #yiv4297798800
div.yiv4297798800file-title a:active, #yiv4297798800
div.yiv4297798800file-title a:hover, #yiv4297798800 div.yiv4297798800file-title
a:visited {text-decoration:none;}#yiv4297798800 div.yiv4297798800photo-title a,
#yiv4297798800 div.yiv4297798800photo-title a:active, #yiv4297798800
div.yiv4297798800photo-title a:hover, #yiv4297798800
div.yiv4297798800photo-title a:visited {text-decoration:none;}#yiv4297798800
div#yiv4297798800ygrp-mlmsg #yiv4297798800ygrp-msg p a
span.yiv4297798800yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4297798800
.yiv4297798800green {color:#628c2a;}#yiv4297798800 .yiv4297798800MsoNormal
{margin:0 0 0 0;}#yiv4297798800 o {font-size:0;}#yiv4297798800
#yiv4297798800photos div {float:left;width:72px;}#yiv4297798800
#yiv4297798800photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4297798800
#yiv4297798800photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4297798800
#yiv4297798800reco-category {font-size:77%;}#yiv4297798800
#yiv4297798800reco-desc {font-size:77%;}#yiv4297798800 .yiv4297798800replbq
{margin:4px;}#yiv4297798800 #yiv4297798800ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4297798800 #yiv4297798800ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4297798800
#yiv4297798800ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4297798800
#yiv4297798800ygrp-mlmsg select, #yiv4297798800 input, #yiv4297798800 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4297798800
#yiv4297798800ygrp-mlmsg pre, #yiv4297798800 code {font:115%
monospace;}#yiv4297798800 #yiv4297798800ygrp-mlmsg *
{line-height:1.22em;}#yiv4297798800 #yiv4297798800ygrp-mlmsg #yiv4297798800logo
{padding-bottom:10px;}#yiv4297798800 #yiv4297798800ygrp-msg p a
{font-family:Verdana;}#yiv4297798800 #yiv4297798800ygrp-msg
p#yiv4297798800attach-count span {color:#1E66AE;font-weight:700;}#yiv4297798800
#yiv4297798800ygrp-reco #yiv4297798800reco-head
{color:#ff7900;font-weight:700;}#yiv4297798800 #yiv4297798800ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4297798800 #yiv4297798800ygrp-sponsor
#yiv4297798800ov li a {font-size:130%;text-decoration:none;}#yiv4297798800
#yiv4297798800ygrp-sponsor #yiv4297798800ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4297798800
#yiv4297798800ygrp-sponsor #yiv4297798800ov ul {margin:0;padding:0 0 0
8px;}#yiv4297798800 #yiv4297798800ygrp-text
{font-family:Georgia;}#yiv4297798800 #yiv4297798800ygrp-text p {margin:0 0 1em
0;}#yiv4297798800 #yiv4297798800ygrp-text tt {font-size:120%;}#yiv4297798800
#yiv4297798800ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4297798800
re_cara+tranpose (pake index match dan kol bantu).xlsx
Description: MS-Excel 2007 spreadsheet
