[belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1 Attachment]

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1 Attachment]

Fatania Latifa
Dear Master Excel,

Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?
Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?
Terima kasih.

Ubah Data Teks Menjadi Baris ke Bawah.xlsx (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Fw: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [2 Attachments]

hendrik karnadi
 Hai Fatania,
Jawaban terlampir pakai jurus Power Query Mr. Kid.Thanks to Mr. Kid.
Regards,HK

   ----- Pesan yang Diteruskan ----- Dari: Fatania Latifa [hidden email] [belajar-excel] <[hidden email]>Kepada: "[hidden email]" <[hidden email]>Terkirim: Selasa, 8 Oktober 2019 13.46.36 GMT+7Judul: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1 Attachment]
    

Dear Master Excel,
Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?Terima kasih.
   

Ubah Data Teks Menjadi Baris ke Bawah.xlsx (14K) Download Attachment
=?UTF-8?b?cmVfVWJhaCBEYXRhIFRla3MgTWVuamFkaSBCYXJpcyBrZSBCYXdhaC54bHN4?= (33K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Fw: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

Fatania Latifa
Dear Pak Hendrik,

Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali. hehe

On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Hai Fatania,
>
> Jawaban terlampir pakai jurus Power Query Mr. Kid.
> Thanks to Mr. Kid.
>
> Regards,
> HK
>
>
> ----- Pesan yang Diteruskan -----
> *Dari:* Fatania Latifa [hidden email] [belajar-excel] <
> [hidden email]>
> *Kepada:* "[hidden email]" <[hidden email]>
> *Terkirim:* Selasa, 8 Oktober 2019 13.46.36 GMT+7
> *Judul:* [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1
> Attachment]
>
>
>
> Dear Master Excel,
>
> Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?
> Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?
> Terima kasih.
>
>
>
Reply | Threaded
Open this post in threaded view
|

RE: Fw: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

iqbal
Dear Fatania

Materi tentang power query sudah pernah di share di group tanggal 1 oktober 2019, judul “Materi Power Query Kopdar III”





Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854







From: [hidden email] <[hidden email]>
Sent: Wednesday, October 9, 2019 10:52 AM
To: [hidden email]
Subject: Re: Fw: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah



 

Dear Pak Hendrik,



Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali. hehe



On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email] <mailto:[hidden email]>  [belajar-excel] <[hidden email] <mailto:[hidden email]> > wrote:



Hai Fatania,



Jawaban terlampir pakai jurus Power Query Mr. Kid.

Thanks to Mr. Kid.



Regards,

HK





----- Pesan yang Diteruskan -----

Dari: Fatania Latifa [hidden email] <mailto:[hidden email]>  [belajar-excel] <[hidden email] <mailto:[hidden email]> >

Kepada: "[hidden email] <mailto:[hidden email]> " <[hidden email] <mailto:[hidden email]> >

Terkirim: Selasa, 8 Oktober 2019 13.46.36 GMT+7

Judul: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1 Attachment]





Dear Master Excel,



Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?

Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?

Terima kasih.



Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

Eira_ariE
In reply to this post by Fatania Latifa
Selamat siang , berikut link materi kopdar dengan materi Power query dan Power Pivot


https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing

tks ..

    On Wednesday, October 9, 2019, 11:07:57 AM GMT+7, Fatania Latifa [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Dear Pak Hendrik,
Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali. hehe

On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> wrote:

  

 Hai Fatania,
Jawaban terlampir pakai jurus Power Query Mr. Kid.Thanks to Mr. Kid.
Regards,HK

   ----- Pesan yang Diteruskan ----- Dari: Fatania Latifa [hidden email] [belajar-excel] <[hidden email]>Kepada: "[hidden email]" <[hidden email]>Terkirim: Selasa, 8 Oktober 2019 13.46.36 GMT+7Judul: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1 Attachment]
  

Dear Master Excel,
Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?Terima kasih.



  #yiv3892306211 #yiv3892306211 -- #yiv3892306211ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3892306211 #yiv3892306211ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3892306211 #yiv3892306211ygrp-mkp #yiv3892306211hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3892306211 #yiv3892306211ygrp-mkp #yiv3892306211ads {margin-bottom:10px;}#yiv3892306211 #yiv3892306211ygrp-mkp .yiv3892306211ad {padding:0 0;}#yiv3892306211 #yiv3892306211ygrp-mkp .yiv3892306211ad p {margin:0;}#yiv3892306211 #yiv3892306211ygrp-mkp .yiv3892306211ad a {color:#0000ff;text-decoration:none;}#yiv3892306211 #yiv3892306211ygrp-sponsor #yiv3892306211ygrp-lc {font-family:Arial;}#yiv3892306211 #yiv3892306211ygrp-sponsor #yiv3892306211ygrp-lc #yiv3892306211hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3892306211 #yiv3892306211ygrp-sponsor #yiv3892306211ygrp-lc .yiv3892306211ad {margin-bottom:10px;padding:0 0;}#yiv3892306211 #yiv3892306211actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3892306211 #yiv3892306211activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3892306211 #yiv3892306211activity span {font-weight:700;}#yiv3892306211 #yiv3892306211activity span:first-child {text-transform:uppercase;}#yiv3892306211 #yiv3892306211activity span a {color:#5085b6;text-decoration:none;}#yiv3892306211 #yiv3892306211activity span span {color:#ff7900;}#yiv3892306211 #yiv3892306211activity span .yiv3892306211underline {text-decoration:underline;}#yiv3892306211 .yiv3892306211attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3892306211 .yiv3892306211attach div a {text-decoration:none;}#yiv3892306211 .yiv3892306211attach img {border:none;padding-right:5px;}#yiv3892306211 .yiv3892306211attach label {display:block;margin-bottom:5px;}#yiv3892306211 .yiv3892306211attach label a {text-decoration:none;}#yiv3892306211 blockquote {margin:0 0 0 4px;}#yiv3892306211 .yiv3892306211bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3892306211 .yiv3892306211bold a {text-decoration:none;}#yiv3892306211 dd.yiv3892306211last p a {font-family:Verdana;font-weight:700;}#yiv3892306211 dd.yiv3892306211last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3892306211 dd.yiv3892306211last p span.yiv3892306211yshortcuts {margin-right:0;}#yiv3892306211 div.yiv3892306211attach-table div div a {text-decoration:none;}#yiv3892306211 div.yiv3892306211attach-table {width:400px;}#yiv3892306211 div.yiv3892306211file-title a, #yiv3892306211 div.yiv3892306211file-title a:active, #yiv3892306211 div.yiv3892306211file-title a:hover, #yiv3892306211 div.yiv3892306211file-title a:visited {text-decoration:none;}#yiv3892306211 div.yiv3892306211photo-title a, #yiv3892306211 div.yiv3892306211photo-title a:active, #yiv3892306211 div.yiv3892306211photo-title a:hover, #yiv3892306211 div.yiv3892306211photo-title a:visited {text-decoration:none;}#yiv3892306211 div#yiv3892306211ygrp-mlmsg #yiv3892306211ygrp-msg p a span.yiv3892306211yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3892306211 .yiv3892306211green {color:#628c2a;}#yiv3892306211 .yiv3892306211MsoNormal {margin:0 0 0 0;}#yiv3892306211 o {font-size:0;}#yiv3892306211 #yiv3892306211photos div {float:left;width:72px;}#yiv3892306211 #yiv3892306211photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3892306211 #yiv3892306211photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3892306211 #yiv3892306211reco-category {font-size:77%;}#yiv3892306211 #yiv3892306211reco-desc {font-size:77%;}#yiv3892306211 .yiv3892306211replbq {margin:4px;}#yiv3892306211 #yiv3892306211ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3892306211 #yiv3892306211ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3892306211 #yiv3892306211ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3892306211 #yiv3892306211ygrp-mlmsg select, #yiv3892306211 input, #yiv3892306211 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3892306211 #yiv3892306211ygrp-mlmsg pre, #yiv3892306211 code {font:115% monospace;}#yiv3892306211 #yiv3892306211ygrp-mlmsg * {line-height:1.22em;}#yiv3892306211 #yiv3892306211ygrp-mlmsg #yiv3892306211logo {padding-bottom:10px;}#yiv3892306211 #yiv3892306211ygrp-msg p a {font-family:Verdana;}#yiv3892306211 #yiv3892306211ygrp-msg p#yiv3892306211attach-count span {color:#1E66AE;font-weight:700;}#yiv3892306211 #yiv3892306211ygrp-reco #yiv3892306211reco-head {color:#ff7900;font-weight:700;}#yiv3892306211 #yiv3892306211ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3892306211 #yiv3892306211ygrp-sponsor #yiv3892306211ov li a {font-size:130%;text-decoration:none;}#yiv3892306211 #yiv3892306211ygrp-sponsor #yiv3892306211ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3892306211 #yiv3892306211ygrp-sponsor #yiv3892306211ov ul {margin:0;padding:0 0 0 8px;}#yiv3892306211 #yiv3892306211ygrp-text {font-family:Georgia;}#yiv3892306211 #yiv3892306211ygrp-text p {margin:0 0 1em 0;}#yiv3892306211 #yiv3892306211ygrp-text tt {font-size:120%;}#yiv3892306211 #yiv3892306211ygrp-vital ul li:last-child {border-right:none !important;}#yiv3892306211
Reply | Threaded
Open this post in threaded view
|

Re: Fw: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

hendrik karnadi
In reply to this post by Fatania Latifa
Sdh dishare oleh mas Iqbal.
Coba disearch.

Salam,
HK

Sent from Yahoo Mail on Android
 
  On Wed, Oct 9, 2019 at 11:08, Fatania Latifa [hidden email] [belajar-excel]<[hidden email]> wrote:      

Dear Pak Hendrik,
Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali. hehe

On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> wrote:

    

 Hai Fatania,
Jawaban terlampir pakai jurus Power Query Mr. Kid.Thanks to Mr. Kid.
Regards,HK

   ----- Pesan yang Diteruskan ----- Dari: Fatania Latifa [hidden email] [belajar-excel] <[hidden email]>Kepada: "[hidden email]" <[hidden email]>Terkirim: Selasa, 8 Oktober 2019 13.46.36 GMT+7Judul: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1 Attachment]
    

Dear Master Excel,
Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?Terima kasih.
   

   
  #yiv0127057028 #yiv0127057028 -- #yiv0127057028ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0127057028 #yiv0127057028ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0127057028 #yiv0127057028ygrp-mkp #yiv0127057028hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0127057028 #yiv0127057028ygrp-mkp #yiv0127057028ads {margin-bottom:10px;}#yiv0127057028 #yiv0127057028ygrp-mkp .yiv0127057028ad {padding:0 0;}#yiv0127057028 #yiv0127057028ygrp-mkp .yiv0127057028ad p {margin:0;}#yiv0127057028 #yiv0127057028ygrp-mkp .yiv0127057028ad a {color:#0000ff;text-decoration:none;}#yiv0127057028 #yiv0127057028ygrp-sponsor #yiv0127057028ygrp-lc {font-family:Arial;}#yiv0127057028 #yiv0127057028ygrp-sponsor #yiv0127057028ygrp-lc #yiv0127057028hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0127057028 #yiv0127057028ygrp-sponsor #yiv0127057028ygrp-lc .yiv0127057028ad {margin-bottom:10px;padding:0 0;}#yiv0127057028 #yiv0127057028actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0127057028 #yiv0127057028activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0127057028 #yiv0127057028activity span {font-weight:700;}#yiv0127057028 #yiv0127057028activity span:first-child {text-transform:uppercase;}#yiv0127057028 #yiv0127057028activity span a {color:#5085b6;text-decoration:none;}#yiv0127057028 #yiv0127057028activity span span {color:#ff7900;}#yiv0127057028 #yiv0127057028activity span .yiv0127057028underline {text-decoration:underline;}#yiv0127057028 .yiv0127057028attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0127057028 .yiv0127057028attach div a {text-decoration:none;}#yiv0127057028 .yiv0127057028attach img {border:none;padding-right:5px;}#yiv0127057028 .yiv0127057028attach label {display:block;margin-bottom:5px;}#yiv0127057028 .yiv0127057028attach label a {text-decoration:none;}#yiv0127057028 blockquote {margin:0 0 0 4px;}#yiv0127057028 .yiv0127057028bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0127057028 .yiv0127057028bold a {text-decoration:none;}#yiv0127057028 dd.yiv0127057028last p a {font-family:Verdana;font-weight:700;}#yiv0127057028 dd.yiv0127057028last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0127057028 dd.yiv0127057028last p span.yiv0127057028yshortcuts {margin-right:0;}#yiv0127057028 div.yiv0127057028attach-table div div a {text-decoration:none;}#yiv0127057028 div.yiv0127057028attach-table {width:400px;}#yiv0127057028 div.yiv0127057028file-title a, #yiv0127057028 div.yiv0127057028file-title a:active, #yiv0127057028 div.yiv0127057028file-title a:hover, #yiv0127057028 div.yiv0127057028file-title a:visited {text-decoration:none;}#yiv0127057028 div.yiv0127057028photo-title a, #yiv0127057028 div.yiv0127057028photo-title a:active, #yiv0127057028 div.yiv0127057028photo-title a:hover, #yiv0127057028 div.yiv0127057028photo-title a:visited {text-decoration:none;}#yiv0127057028 div#yiv0127057028ygrp-mlmsg #yiv0127057028ygrp-msg p a span.yiv0127057028yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0127057028 .yiv0127057028green {color:#628c2a;}#yiv0127057028 .yiv0127057028MsoNormal {margin:0 0 0 0;}#yiv0127057028 o {font-size:0;}#yiv0127057028 #yiv0127057028photos div {float:left;width:72px;}#yiv0127057028 #yiv0127057028photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0127057028 #yiv0127057028photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0127057028 #yiv0127057028reco-category {font-size:77%;}#yiv0127057028 #yiv0127057028reco-desc {font-size:77%;}#yiv0127057028 .yiv0127057028replbq {margin:4px;}#yiv0127057028 #yiv0127057028ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0127057028 #yiv0127057028ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0127057028 #yiv0127057028ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0127057028 #yiv0127057028ygrp-mlmsg select, #yiv0127057028 input, #yiv0127057028 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0127057028 #yiv0127057028ygrp-mlmsg pre, #yiv0127057028 code {font:115% monospace;}#yiv0127057028 #yiv0127057028ygrp-mlmsg * {line-height:1.22em;}#yiv0127057028 #yiv0127057028ygrp-mlmsg #yiv0127057028logo {padding-bottom:10px;}#yiv0127057028 #yiv0127057028ygrp-msg p a {font-family:Verdana;}#yiv0127057028 #yiv0127057028ygrp-msg p#yiv0127057028attach-count span {color:#1E66AE;font-weight:700;}#yiv0127057028 #yiv0127057028ygrp-reco #yiv0127057028reco-head {color:#ff7900;font-weight:700;}#yiv0127057028 #yiv0127057028ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0127057028 #yiv0127057028ygrp-sponsor #yiv0127057028ov li a {font-size:130%;text-decoration:none;}#yiv0127057028 #yiv0127057028ygrp-sponsor #yiv0127057028ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0127057028 #yiv0127057028ygrp-sponsor #yiv0127057028ov ul {margin:0;padding:0 0 0 8px;}#yiv0127057028 #yiv0127057028ygrp-text {font-family:Georgia;}#yiv0127057028 #yiv0127057028ygrp-text p {margin:0 0 1em 0;}#yiv0127057028 #yiv0127057028ygrp-text tt {font-size:120%;}#yiv0127057028 #yiv0127057028ygrp-vital ul li:last-child {border-right:none !important;}#yiv0127057028  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

ghozi alkatiri
In reply to this post by iqbal
 
kalau mau menggunakan  mega formula 

 tulis formula di 

F3(nama kota)

=IF(ROWS(F$2:F3)>SUMPRODUCT(LEN($B$3:$B$5))-SUMPRODUCT(LEN(SUBSTITUTE($B$3:$B$5,",",)))+COUNTA($A$3:$A$5),"",(IF(COUNTIF($A$3:$A$5,F2)=0,$A$3,IF(COUNTIF(F$1:F2,INDEX($A$3:$A$5,MATCH(F2,$A$3:$A$5,0)))<SUMPRODUCT(((MID(INDEX($B$3:$B$5,MATCH(F2,$A$3:$A$5,0)),ROW($A$1:$A$100),1)=",")*1))+1,INDEX($A$3:$A$5,MATCH(F2,$A$3:$A$5,0)),INDEX($A$3:$A$5,MATCH(F2,$A$3:$A$5,0)+1)))))


copy ke bawah



diG3 (angka)


=IFERROR(TRIM(MID(SUBSTITUTE(INDEX($B$3:$B$5,MATCH(F3,$A$3:$A$5,0)),",",REPT("",100)),(COUNTIF(F$2:F3,F3)-1)*100+1,100)),"")



copy ke bawah



wassalam

Ghozi  Alkatiri

    Pada Rabu, 9 Oktober 2019 13.11.44 WIB, [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    


Dear Fatania

Materi tentang power query sudah pernah di share di group tanggal 1 oktober 2019, judul “Materi Power Query Kopdar III”

  

  

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

  

  

  

From: [hidden email] <[hidden email]>
Sent: Wednesday, October 9, 2019 10:52 AM
To: [hidden email]
Subject: Re: Fw: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

  

 

Dear Pak Hendrik,

  

Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali. hehe

  

On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> wrote:


 

Hai Fatania,

  

Jawaban terlampir pakai jurus Power Query Mr. Kid.

Thanks to Mr. Kid.

  

Regards,

HK

  

  

----- Pesan yang Diteruskan -----

Dari: Fatania Latifa [hidden email] [belajar-excel] <[hidden email]>

Kepada: "[hidden email]" <[hidden email]>

Terkirim: Selasa, 8 Oktober 2019 13.46.36 GMT+7

Judul: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1 Attachment]

  

 

Dear Master Excel,

  

Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?

Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?

Terima kasih..



  #yiv7846087628 #yiv7846087628 -- #yiv7846087628ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7846087628 #yiv7846087628ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7846087628 #yiv7846087628ygrp-mkp #yiv7846087628hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7846087628 #yiv7846087628ygrp-mkp #yiv7846087628ads {margin-bottom:10px;}#yiv7846087628 #yiv7846087628ygrp-mkp .yiv7846087628ad {padding:0 0;}#yiv7846087628 #yiv7846087628ygrp-mkp .yiv7846087628ad p {margin:0;}#yiv7846087628 #yiv7846087628ygrp-mkp .yiv7846087628ad a {color:#0000ff;text-decoration:none;}#yiv7846087628 #yiv7846087628ygrp-sponsor #yiv7846087628ygrp-lc {font-family:Arial;}#yiv7846087628 #yiv7846087628ygrp-sponsor #yiv7846087628ygrp-lc #yiv7846087628hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7846087628 #yiv7846087628ygrp-sponsor #yiv7846087628ygrp-lc .yiv7846087628ad {margin-bottom:10px;padding:0 0;}#yiv7846087628 #yiv7846087628actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7846087628 #yiv7846087628activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7846087628 #yiv7846087628activity span {font-weight:700;}#yiv7846087628 #yiv7846087628activity span:first-child {text-transform:uppercase;}#yiv7846087628 #yiv7846087628activity span a {color:#5085b6;text-decoration:none;}#yiv7846087628 #yiv7846087628activity span span {color:#ff7900;}#yiv7846087628 #yiv7846087628activity span .yiv7846087628underline {text-decoration:underline;}#yiv7846087628 .yiv7846087628attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7846087628 .yiv7846087628attach div a {text-decoration:none;}#yiv7846087628 .yiv7846087628attach img {border:none;padding-right:5px;}#yiv7846087628 .yiv7846087628attach label {display:block;margin-bottom:5px;}#yiv7846087628 .yiv7846087628attach label a {text-decoration:none;}#yiv7846087628 blockquote {margin:0 0 0 4px;}#yiv7846087628 .yiv7846087628bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7846087628 .yiv7846087628bold a {text-decoration:none;}#yiv7846087628 dd.yiv7846087628last p a {font-family:Verdana;font-weight:700;}#yiv7846087628 dd.yiv7846087628last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7846087628 dd.yiv7846087628last p span.yiv7846087628yshortcuts {margin-right:0;}#yiv7846087628 div.yiv7846087628attach-table div div a {text-decoration:none;}#yiv7846087628 div.yiv7846087628attach-table {width:400px;}#yiv7846087628 div.yiv7846087628file-title a, #yiv7846087628 div.yiv7846087628file-title a:active, #yiv7846087628 div.yiv7846087628file-title a:hover, #yiv7846087628 div.yiv7846087628file-title a:visited {text-decoration:none;}#yiv7846087628 div.yiv7846087628photo-title a, #yiv7846087628 div.yiv7846087628photo-title a:active, #yiv7846087628 div.yiv7846087628photo-title a:hover, #yiv7846087628 div.yiv7846087628photo-title a:visited {text-decoration:none;}#yiv7846087628 div#yiv7846087628ygrp-mlmsg #yiv7846087628ygrp-msg p a span.yiv7846087628yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7846087628 .yiv7846087628green {color:#628c2a;}#yiv7846087628 .yiv7846087628MsoNormal {margin:0 0 0 0;}#yiv7846087628 o {font-size:0;}#yiv7846087628 #yiv7846087628photos div {float:left;width:72px;}#yiv7846087628 #yiv7846087628photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7846087628 #yiv7846087628photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7846087628 #yiv7846087628reco-category {font-size:77%;}#yiv7846087628 #yiv7846087628reco-desc {font-size:77%;}#yiv7846087628 .yiv7846087628replbq {margin:4px;}#yiv7846087628 #yiv7846087628ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7846087628 #yiv7846087628ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7846087628 #yiv7846087628ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7846087628 #yiv7846087628ygrp-mlmsg select, #yiv7846087628 input, #yiv7846087628 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7846087628 #yiv7846087628ygrp-mlmsg pre, #yiv7846087628 code {font:115% monospace;}#yiv7846087628 #yiv7846087628ygrp-mlmsg * {line-height:1.22em;}#yiv7846087628 #yiv7846087628ygrp-mlmsg #yiv7846087628logo {padding-bottom:10px;}#yiv7846087628 #yiv7846087628ygrp-msg p a {font-family:Verdana;}#yiv7846087628 #yiv7846087628ygrp-msg p#yiv7846087628attach-count span {color:#1E66AE;font-weight:700;}#yiv7846087628 #yiv7846087628ygrp-reco #yiv7846087628reco-head {color:#ff7900;font-weight:700;}#yiv7846087628 #yiv7846087628ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7846087628 #yiv7846087628ygrp-sponsor #yiv7846087628ov li a {font-size:130%;text-decoration:none;}#yiv7846087628 #yiv7846087628ygrp-sponsor #yiv7846087628ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7846087628 #yiv7846087628ygrp-sponsor #yiv7846087628ov ul {margin:0;padding:0 0 0 8px;}#yiv7846087628 #yiv7846087628ygrp-text {font-family:Georgia;}#yiv7846087628 #yiv7846087628ygrp-text p {margin:0 0 1em 0;}#yiv7846087628 #yiv7846087628ygrp-text tt {font-size:120%;}#yiv7846087628 #yiv7846087628ygrp-vital ul li:last-child {border-right:none !important;}#yiv7846087628  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

Fatania Latifa
In reply to this post by Eira_ariE
Terima kasih banyak infonya, udah mulai nyicil sedikit2

On Wed, Oct 9, 2019 at 12:28 PM Eira I Arie [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Selamat siang , berikut link materi kopdar dengan materi Power query dan
> Power Pivot
>
>
>
> *https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing
> <https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing>*
>
> *tks ..*
>
>
> On Wednesday, October 9, 2019, 11:07:57 AM GMT+7, Fatania Latifa
> [hidden email] [belajar-excel] <[hidden email]>
> wrote:
>
>
>
>
> Dear Pak Hendrik,
>
> Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali.
> hehe
>
> On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>
>
> Hai Fatania,
>
> Jawaban terlampir pakai jurus Power Query Mr. Kid.
> Thanks to Mr. Kid.
>
> Regards,
> HK
>
>
> ----- Pesan yang Diteruskan -----
> *Dari:* Fatania Latifa [hidden email]
> <[hidden email]> [belajar-excel] <[hidden email]>
> *Kepada:* "[hidden email]" <[hidden email]
> <belajar-excel@yahoogroups..com>>
> *Terkirim:* Selasa, 8 Oktober 2019 13.46.36 GMT+7
> *Judul:* [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1
> Attachment]
>
>
>
> Dear Master Excel,
>
> Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?
> Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?
> Terima kasih..
>
>
>
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1 Attachment]

Kid
Administrator
Terlampir dengan power query dan formula. Sila pilih satu dari tiga cara
yang ada.

Regards,
Kid


On Wed, Oct 9, 2019 at 9:26 PM Fatania Latifa [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Terima kasih banyak infonya, udah mulai nyicil sedikit2
>
> On Wed, Oct 9, 2019 at 12:28 PM Eira I Arie [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>>
>>
>> Selamat siang , berikut link materi kopdar dengan materi Power query dan
>> Power Pivot
>>
>>
>>
>> *https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing
>> <https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing>*
>>
>> *tks ..*
>>
>>
>> On Wednesday, October 9, 2019, 11:07:57 AM GMT+7, Fatania Latifa
>> [hidden email] [belajar-excel] <[hidden email]>
>> wrote:
>>
>>
>>
>>
>> Dear Pak Hendrik,
>>
>> Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali.
>> hehe
>>
>> On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email]
>> [belajar-excel] <[hidden email]> wrote:
>>
>>
>>
>> Hai Fatania,
>>
>> Jawaban terlampir pakai jurus Power Query Mr. Kid.
>> Thanks to Mr. Kid.
>>
>> Regards,
>> HK
>>
>>
>> ----- Pesan yang Diteruskan -----
>> *Dari:* Fatania Latifa [hidden email]
>> <[hidden email]> [belajar-excel] <[hidden email]
>> >
>> *Kepada:* "[hidden email]" <[hidden email]
>> <belajar-excel@yahoogroups..com>>
>> *Terkirim:* Selasa, 8 Oktober 2019 13.46.36 GMT+7
>> *Judul:* [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1
>> Attachment]
>>
>>
>>
>> Dear Master Excel,
>>
>> Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?
>> Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?
>> Terima kasih..
>>
>>
>

re-Ubah Data Teks Menjadi Baris ke Bawah.xlsx (32K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

Fatania Latifa
Terima kasih banyak Mr.Kid, keren emang.. tapi untuk formula yang 1 cell
ketika saya insert data, kolom kanannya menjadi kosong.

[image: image.png]

Masih belum paham sama formula yang ada. hehe

On Thu, Oct 10, 2019 at 12:55 AM 'Mr. Kid' [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Terlampir dengan power query dan formula. Sila pilih satu dari tiga cara
> yang ada.
>
> Regards,
> Kid
>
>
> On Wed, Oct 9, 2019 at 9:26 PM Fatania Latifa [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>>
>>
>> Terima kasih banyak infonya, udah mulai nyicil sedikit2
>>
>> On Wed, Oct 9, 2019 at 12:28 PM Eira I Arie [hidden email]
>> [belajar-excel] <[hidden email]> wrote:
>>
>>>
>>>
>>> Selamat siang , berikut link materi kopdar dengan materi Power query dan
>>> Power Pivot
>>>
>>>
>>>
>>> *https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing
>>> <https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing>*
>>>
>>> *tks ..*
>>>
>>>
>>> On Wednesday, October 9, 2019, 11:07:57 AM GMT+7, Fatania Latifa
>>> [hidden email] [belajar-excel] <[hidden email]>
>>> wrote:
>>>
>>>
>>>
>>>
>>> Dear Pak Hendrik,
>>>
>>> Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali.
>>> hehe
>>>
>>> On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email]
>>> [belajar-excel] <[hidden email]> wrote:
>>>
>>>
>>>
>>> Hai Fatania,
>>>
>>> Jawaban terlampir pakai jurus Power Query Mr. Kid.
>>> Thanks to Mr. Kid.
>>>
>>> Regards,
>>> HK
>>>
>>>
>>> ----- Pesan yang Diteruskan -----
>>> *Dari:* Fatania Latifa [hidden email]
>>> <[hidden email]> [belajar-excel] <
>>> [hidden email]>
>>> *Kepada:* "[hidden email]" <[hidden email]
>>> <belajar-excel@yahoogroups..com>>
>>> *Terkirim:* Selasa, 8 Oktober 2019 13.46.36 GMT+7
>>> *Judul:* [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1
>>> Attachment]
>>>
>>>
>>>
>>> Dear Master Excel,
>>>
>>> Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?
>>> Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana ya?
>>> Terima kasih..
>>>
>>>
>

image.png (51K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah

Fatania Latifa
Oh sepertinya yang formula kedua, apabila data sumber identik sama,
kolomnya tidak terbaca. case closed, terima kasih, saya utak atik sendiri.

On Mon, Oct 14, 2019 at 9:31 AM Fatania Latifa <[hidden email]>
wrote:

> Terima kasih banyak Mr.Kid, keren emang.. tapi untuk formula yang 1 cell
> ketika saya insert data, kolom kanannya menjadi kosong.
>
> [image: image.png]
>
> Masih belum paham sama formula yang ada. hehe
>
> On Thu, Oct 10, 2019 at 12:55 AM 'Mr. Kid' [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>>
>>
>> Terlampir dengan power query dan formula. Sila pilih satu dari tiga cara
>> yang ada.
>>
>> Regards,
>> Kid
>>
>>
>> On Wed, Oct 9, 2019 at 9:26 PM Fatania Latifa [hidden email]
>> [belajar-excel] <[hidden email]> wrote:
>>
>>>
>>>
>>> Terima kasih banyak infonya, udah mulai nyicil sedikit2
>>>
>>> On Wed, Oct 9, 2019 at 12:28 PM Eira I Arie [hidden email]
>>> [belajar-excel] <[hidden email]> wrote:
>>>
>>>>
>>>>
>>>> Selamat siang , berikut link materi kopdar dengan materi Power query
>>>> dan Power Pivot
>>>>
>>>>
>>>>
>>>> *https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing
>>>> <https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing>*
>>>>
>>>> *tks ..*
>>>>
>>>>
>>>> On Wednesday, October 9, 2019, 11:07:57 AM GMT+7, Fatania Latifa
>>>> [hidden email] [belajar-excel] <[hidden email]>
>>>> wrote:
>>>>
>>>>
>>>>
>>>>
>>>> Dear Pak Hendrik,
>>>>
>>>> Ada link tentang power query Mr. Kid? krn saya belum paham sama sekali.
>>>> hehe
>>>>
>>>> On Tue, Oct 8, 2019 at 4:58 PM hendrik karnadi [hidden email]
>>>> [belajar-excel] <[hidden email]> wrote:
>>>>
>>>>
>>>>
>>>> Hai Fatania,
>>>>
>>>> Jawaban terlampir pakai jurus Power Query Mr. Kid.
>>>> Thanks to Mr. Kid.
>>>>
>>>> Regards,
>>>> HK
>>>>
>>>>
>>>> ----- Pesan yang Diteruskan -----
>>>> *Dari:* Fatania Latifa [hidden email]
>>>> <[hidden email]> [belajar-excel] <
>>>> [hidden email]>
>>>> *Kepada:* "[hidden email]" <
>>>> [hidden email] <belajar-excel@yahoogroups..com>>
>>>> *Terkirim:* Selasa, 8 Oktober 2019 13.46.36 GMT+7
>>>> *Judul:* [belajar-excel] Ubah Data Teks Menjadi Baris ke Bawah [1
>>>> Attachment]
>>>>
>>>>
>>>>
>>>> Dear Master Excel,
>>>>
>>>> Bagaimana cara mengubah data di 1 kolom menjadi baris ke bawah?
>>>> Kalau ke samping kan memakai Text to Column, kalau ke bawah bagaimana
>>>> ya?
>>>> Terima kasih..
>>>>
>>>>
>>
>

image.png (51K) Download Attachment