Mengubah Urutan di Excel

Fathoni
28 Jan, 2015
Gunakan opsi 'Paste Khusus Transpose' untuk beralih baris untuk kolom atau kolom untuk baris di Excel. Anda juga dapat menggunakan fungsi transpose.

Paste Transpose Khusus
Untuk merefleksikan data, jalankan langkah-langkah berikut.

1. Pilih rentang A1: C1.

2. Klik kanan, lalu klik Copy.
3. Pilih sel E2.

4. Klik kanan, lalu klik Paste Special ...

5. Periksa transpose.
6. Klik OK.
Transpose Fungsi
Untuk memasukkan fungsi transpose, jalankan langkah-langkah berikut.

1. Pertama, pilih rentang baru dari sel.
2. Ketik = transpose (

3. Pilih rentang A1: C1 dan dekat dengan kurung.
4. Akhiri dengan menekan CTRL + SHIFT + ENTER.
Catatan: Formula bar menunjukkan bahwa ini adalah sebuah formula array dengan melampirkan dalam kurung kurawal {}. Untuk menghapus array formula ini, pilih rentang E2: E4 dan tekan Delete.
Add Comment
<!--

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY4XBym_seMQJn0GBQo0USRMXCtLrg:1732339523780';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d3976261034658282476','//icollecta.blogspot.com/2015/01/mengubah-urutan-di-excel.html','3976261034658282476');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '3976261034658282476', 'title': 'All for You', 'url': 'https://icollecta.blogspot.com/2015/01/mengubah-urutan-di-excel.html', 'canonicalUrl': 'https://icollecta.blogspot.com/2015/01/mengubah-urutan-di-excel.html', 'homepageUrl': 'https://icollecta.blogspot.com/', 'searchUrl': 'https://icollecta.blogspot.com/search', 'canonicalHomepageUrl': 'https://icollecta.blogspot.com/', 'blogspotFaviconUrl': 'https://icollecta.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-38705278-1', 'encoding': 'UTF-8', 'locale': 'id', 'localeUnderscoreDelimited': 'id', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22All for You - Atom\x22 href\x3d\x22https://icollecta.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22All for You - RSS\x22 href\x3d\x22https://icollecta.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22All for You - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/3976261034658282476/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22All for You - Atom\x22 href\x3d\x22https://icollecta.blogspot.com/feeds/2482565412749166119/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-1560747079619197', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/d78375fb222d99b3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Dapatkan link', 'key': 'link', 'shareMessage': 'Dapatkan link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Bagikan ke Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Bagikan ke X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Bagikan ke Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27id\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '2482565412749166119', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuuwJzu6XxP0wHHoYDQnFs9cxiEO6RYXlBSpkvY8BLQUTBBKlvFVeTBWWWINQQMYj90vbUxBWlQD-z1U9D1GHTpBP3pXeK611SCwCGTPPUZ7qCD7c65wLeHJ6-3d9dgjb-zMBlCHKAayWi/s72-c/right-click-copy.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuuwJzu6XxP0wHHoYDQnFs9cxiEO6RYXlBSpkvY8BLQUTBBKlvFVeTBWWWINQQMYj90vbUxBWlQD-z1U9D1GHTpBP3pXeK611SCwCGTPPUZ7qCD7c65wLeHJ6-3d9dgjb-zMBlCHKAayWi/s1600/right-click-copy.png', 'pageName': 'Mengubah Urutan di Excel', 'pageTitle': 'All for You: Mengubah Urutan di Excel'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Tautan disalin ke papan klip!', 'ok': 'Oke', 'postLink': 'Tautan Pos'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Khusus', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Mengubah Urutan di Excel', 'description': 'Gunakan opsi \x27Paste Khusus Transpose\x27 untuk beralih baris untuk kolom atau kolom untuk baris di Excel. Anda juga dapat menggunakan fungsi tr...', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuuwJzu6XxP0wHHoYDQnFs9cxiEO6RYXlBSpkvY8BLQUTBBKlvFVeTBWWWINQQMYj90vbUxBWlQD-z1U9D1GHTpBP3pXeK611SCwCGTPPUZ7qCD7c65wLeHJ6-3d9dgjb-zMBlCHKAayWi/s1600/right-click-copy.png', 'url': 'https://icollecta.blogspot.com/2015/01/mengubah-urutan-di-excel.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 2482565412749166119}}, {'name': 'widgets', 'data': [{'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML50'}, {'title': '#Search and Icons', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList52'}, {'title': 'Menu', 'type': 'PageList', 'sectionId': 'header-main', 'id': 'PageList50'}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost50', 'postId': '7436093338637726709'}, {'title': 'Postingan Blog', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog50', 'posts': [{'id': '2482565412749166119', 'title': 'Mengubah Urutan di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuuwJzu6XxP0wHHoYDQnFs9cxiEO6RYXlBSpkvY8BLQUTBBKlvFVeTBWWWINQQMYj90vbUxBWlQD-z1U9D1GHTpBP3pXeK611SCwCGTPPUZ7qCD7c65wLeHJ6-3d9dgjb-zMBlCHKAayWi/s1600/right-click-copy.png', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Diposting oleh'}, {'name': 'comments', 'label': 'Review'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Diposting oleh'}, {'name': 'comments', 'label': 'Review'}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML1'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts50', 'posts': [{'title': 'Connectify Hotspot Pro \x26amp; Dispatch Pro 8.0.0.30686', 'id': 2655570637012845177}, {'title': 'Beungong Meulu dan Beungong Peukeun', 'id': 3504814329225322177}, {'title': 'Soekarno: Proklamator dan Presiden Pertama Indonesia', 'id': 8308504018676453940}, {'title': 'Ice Age 4 Continental Drift (2012) DVDRip', 'id': 1898697824908181274}, {'title': 'Pertolongan Pertama Balita Mengalami Demam Tinggi', 'id': 2682847614426360496}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label50'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML55'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList50'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList51'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML58'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML56'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML57'}, {'title': 'JetScript Options', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML59'}]}]);
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML50', 'header-main', document.getElementById('HTML50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList52', 'header-main', document.getElementById('LinkList52'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList50', 'header-main', document.getElementById('PageList50'), {'title': 'Menu', 'links': [{'isCurrentPage': false, 'href': '/p/about.html', 'title': 'About'}, {'isCurrentPage': false, 'href': '/search/label/Teknologi?max-results\x3d10', 'title': 'Tech'}, {'isCurrentPage': false, 'href': '#sub-start', 'title': 'Dropdown'}, {'isCurrentPage': false, 'href': '/search/label/Windows?max-results\x3d10', 'title': 'Windows'}, {'isCurrentPage': false, 'href': '#sub-start', 'title': 'Dropdown'}, {'isCurrentPage': false, 'href': '/search/label/Software?max-results\x3d10', 'title': 'Windows Software'}, {'isCurrentPage': false, 'href': '/search/label/Windows%20OS?max-results\x3d10', 'title': 'Windows OS'}, {'isCurrentPage': false, 'href': '#sub-end', 'title': 'Dropdown-#2'}, {'isCurrentPage': false, 'href': '#', 'title': 'Android'}, {'isCurrentPage': false, 'href': '#sub-end', 'title': 'Sub Menu #1'}, {'isCurrentPage': false, 'href': '/p/contact.html', 'title': 'Contact'}, {'isCurrentPage': false, 'href': '/p/sitemap.html', 'title': 'Sitemap'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost50', 'before-blog', document.getElementById('FeaturedPost50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog50', 'blog-post', document.getElementById('Blog50'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2646514562-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'ads-post', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts50', 'sidebar-static', document.getElementById('PopularPosts50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label50', 'sidebar-static', document.getElementById('Label50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML55', 'footer-widget', document.getElementById('HTML55'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList50', 'footer-widget', document.getElementById('LinkList50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList51', 'footer-widget', document.getElementById('LinkList51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML58', 'footer-widget', document.getElementById('HTML58'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML56', 'copyright', document.getElementById('HTML56'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML57', 'jet-options', document.getElementById('HTML57'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML59', 'jet-options', document.getElementById('HTML59'), {}, 'displayModeFull'));
</script>
</body>

-->
Popular Posts

Connectify Hotspot Pro & Dispatch Pro 8.0.0.30686

Beungong Meulu dan Beungong Peukeun

Soekarno: Proklamator dan Presiden Pertama Indonesia

Ice Age 4 Continental Drift (2012) DVDRip

Pertolongan Pertama Balita Mengalami Demam Tinggi

Categories
