{"id":1419,"date":"2019-07-08T16:00:41","date_gmt":"2019-07-08T22:00:41","guid":{"rendered":"https:\/\/www.brendapenman.com\/?p=1419"},"modified":"2021-11-21T16:12:41","modified_gmt":"2021-11-21T23:12:41","slug":"excel_transpose","status":"publish","type":"post","link":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/","title":{"rendered":"Flip or Transpose Your Excel Data"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”3.24″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ collapsed=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Do you want to Flip your Excel Data from Rows to Columns, or vice versa?<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

After working with your Excel data for a while, you may decide that the information would be better if it was flipped. For example, you may wish to have the Days of the Week displayed horizontally across the columns, instead of vertically listed by row.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/05\/Transpose0C.png” _builder_version=”3.23.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Instead of manually re-typing all of your data, use the Transpose<\/strong> feature. Transpose<\/strong> is used to change a vertical range of cells to a horizontal range or vice versa.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

To Transpose Excel Data:<\/h2>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ module_alignment=”left” custom_margin=”|||” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

1.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Select the range of cells you wish to Transpose<\/strong>.<\/p>\n

e.g. On Sheet 1 select cells Al to D8\u00a0<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/05\/Transpose1C.png” align=”center” _builder_version=”3.23.2″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

2.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Press Ctrl + C<\/strong> to copy these cells.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

3.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Go to the Cell where you want the Transposed Excel Data.<\/p>\n

You may go to a Cell in the current worksheet or in another worksheet.<\/p>\n

Note:<\/strong>\u00a0Make sure you go to a Cell outside of the Current Selection.<\/p>\n

e.g. Go to Sheet 2 and Click cell A1<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/05\/Transpose3C.png” align=”center” _builder_version=”3.23.2″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

4.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

On the Home<\/strong> tab, in the Clipboard<\/strong> group, click Paste Options<\/strong>, click Transpose<\/strong>.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/05\/Transpose4C.png” align=”center” _builder_version=”3.23.2″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

In our example, the Days of the Week are now displayed horizontally across the columns.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/05\/Transpose5C.png” align=”center” _builder_version=”3.23.2″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

The Transpose<\/strong> feature saves you hours of manual work.<\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”]<\/p>\n

Please share this with other Excel users and save them hours of manual work.<\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ text_text_color=”#00a4e4″ text_font_size=”22px” text_orientation=”center” custom_margin=”0px||0px” custom_padding=”0px||0px” text_text_align=”center” global_colors_info=”{}”]<\/p>\n

~ Let Microsoft Excel do the work for you. ~<\/strong><\/em><\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.24″ custom_margin=”0px||” custom_padding=”0px|20px||20px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_comments show_count=”off” _builder_version=”4.13.0″ form_field_background_color=”#ffffff” form_field_text_color=”#333333″ header_font=”Montserrat||||||||” body_font=”||||||||” form_field_font=”||||||||” form_field_text_align=”left” custom_button=”on” button_text_color=”#ffffff” button_bg_color=”#00A4E4″ button_border_color=”#00A4E4″ button_font=”Montserrat|600|||||||” button_icon=”E||divi||400″ button_icon_color=”#ffffff” button_alignment=”right” custom_margin=”0px||0px” custom_padding=”0px|0px|0px|0px” border_width_all_fields=”1px” border_color_all_fields=”#dbdbdb” border_style_all_fields=”ridge” box_shadow_style_fields=”preset3″ box_shadow_style_button=”preset2″ global_colors_info=”{}”][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Do you want to Change your Excel Data from Rows to Columns, or vice versa?
\nDon’t re-type your data, flip or transpose your data.
\ne.g. To change the Days of the Week to display horizontally instead of vertically. Discover what the steps are here […] <\/p>\n","protected":false},"author":1,"featured_media":2258,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[2],"tags":[44,12,36,25,24,52,26,27,14,28,29,30,31,32,35,33,34,37,38,39,41,40,42,43],"class_list":["post-1419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","tag-columns-and-rows","tag-excel","tag-excel-2013","tag-excel-2016","tag-excel-2019","tag-excel-calculations","tag-excel-tips","tag-excel-transpose","tag-flip","tag-flip-columns-and-rows","tag-flip-from-horizontal-to-vertical","tag-flip-from-vertical-to-horizontal","tag-flip-rows-and-columns","tag-microsoft-excel","tag-microsoft-excel-2013","tag-microsoft-excel-2016","tag-microsoft-excel-2019","tag-moving-data-blocks","tag-moving-excel-data-blocks-from-horizontal-to-vertical","tag-moving-excel-data-blocks-from-vertical-to-horizontal","tag-paste-special","tag-transpose","tag-transpose-columns-and-rows","tag-transpose-rows-and-columns"],"yoast_head":"\nFlip or Transpose Your Excel Data - Brenda Penman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flip or Transpose Your Excel Data - Brenda Penman\" \/>\n<meta property=\"og:description\" content=\"Do you want to Change your Excel Data from Rows to Columns, or vice versa? Don't re-type your data, flip or transpose your data. e.g. To change the Days of the Week to display horizontally instead of vertically. Discover what the steps are here [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/\" \/>\n<meta property=\"og:site_name\" content=\"Brenda Penman\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-08T22:00:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-21T23:12:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/Excel-transpose5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"718\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brenda Penman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brenda Penman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/\"},\"author\":{\"name\":\"Brenda Penman\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"headline\":\"Flip or Transpose Your Excel Data\",\"datePublished\":\"2019-07-08T22:00:41+00:00\",\"dateModified\":\"2021-11-21T23:12:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/\"},\"wordCount\":1321,\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/Excel-transpose5.png\",\"keywords\":[\"Columns and Rows\",\"Excel\",\"Excel 2013\",\"Excel 2016\",\"Excel 2019\",\"Excel Calculations\",\"Excel Tips\",\"Excel Transpose\",\"Flip\",\"Flip Columns and Rows\",\"Flip from Horizontal to Vertical\",\"Flip from Vertical to Horizontal\",\"Flip Rows and Columns\",\"Microsoft Excel\",\"Microsoft Excel 2013\",\"Microsoft Excel 2016\",\"Microsoft Excel 2019\",\"Moving Data Blocks\",\"Moving Excel Data Blocks from Horizontal to Vertical\",\"Moving Excel Data Blocks from Vertical to Horizontal\",\"Paste Special\",\"Transpose\",\"Transpose Columns and Rows\",\"Transpose Rows and Columns\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/\",\"name\":\"Flip or Transpose Your Excel Data - Brenda Penman\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/Excel-transpose5.png\",\"datePublished\":\"2019-07-08T22:00:41+00:00\",\"dateModified\":\"2021-11-21T23:12:41+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/Excel-transpose5.png\",\"contentUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/Excel-transpose5.png\",\"width\":1080,\"height\":718,\"caption\":\"Flip or Transpose Your Excel Data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_transpose\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Flip or Transpose Your Excel Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\",\"name\":\"Brenda Penman\",\"description\":\"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\",\"name\":\"Brenda Penman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"caption\":\"Brenda Penman\"},\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/author\\\/mfvwwyzbgoqzie\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flip or Transpose Your Excel Data - Brenda Penman","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/","og_locale":"en_US","og_type":"article","og_title":"Flip or Transpose Your Excel Data - Brenda Penman","og_description":"Do you want to Change your Excel Data from Rows to Columns, or vice versa? Don't re-type your data, flip or transpose your data. e.g. To change the Days of the Week to display horizontally instead of vertically. Discover what the steps are here [...]","og_url":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/","og_site_name":"Brenda Penman","article_published_time":"2019-07-08T22:00:41+00:00","article_modified_time":"2021-11-21T23:12:41+00:00","og_image":[{"width":1080,"height":718,"url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/Excel-transpose5.png","type":"image\/png"}],"author":"Brenda Penman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Brenda Penman","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/#article","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/"},"author":{"name":"Brenda Penman","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"headline":"Flip or Transpose Your Excel Data","datePublished":"2019-07-08T22:00:41+00:00","dateModified":"2021-11-21T23:12:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/"},"wordCount":1321,"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/Excel-transpose5.png","keywords":["Columns and Rows","Excel","Excel 2013","Excel 2016","Excel 2019","Excel Calculations","Excel Tips","Excel Transpose","Flip","Flip Columns and Rows","Flip from Horizontal to Vertical","Flip from Vertical to Horizontal","Flip Rows and Columns","Microsoft Excel","Microsoft Excel 2013","Microsoft Excel 2016","Microsoft Excel 2019","Moving Data Blocks","Moving Excel Data Blocks from Horizontal to Vertical","Moving Excel Data Blocks from Vertical to Horizontal","Paste Special","Transpose","Transpose Columns and Rows","Transpose Rows and Columns"],"articleSection":["Microsoft Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/","url":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/","name":"Flip or Transpose Your Excel Data - Brenda Penman","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/#primaryimage"},"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/Excel-transpose5.png","datePublished":"2019-07-08T22:00:41+00:00","dateModified":"2021-11-21T23:12:41+00:00","author":{"@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"breadcrumb":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.brendapenman.com\/blog\/excel_transpose\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/#primaryimage","url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/Excel-transpose5.png","contentUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/Excel-transpose5.png","width":1080,"height":718,"caption":"Flip or Transpose Your Excel Data"},{"@type":"BreadcrumbList","@id":"https:\/\/www.brendapenman.com\/blog\/excel_transpose\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.brendapenman.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Flip or Transpose Your Excel Data"}]},{"@type":"WebSite","@id":"https:\/\/www.brendapenman.com\/blog\/#website","url":"https:\/\/www.brendapenman.com\/blog\/","name":"Brenda Penman","description":"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.brendapenman.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef","name":"Brenda Penman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","caption":"Brenda Penman"},"url":"https:\/\/www.brendapenman.com\/blog\/author\/mfvwwyzbgoqzie\/"}]}},"_links":{"self":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/1419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/comments?post=1419"}],"version-history":[{"count":5,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/1419\/revisions"}],"predecessor-version":[{"id":3513,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/1419\/revisions\/3513"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media\/2258"}],"wp:attachment":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media?parent=1419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/categories?post=1419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/tags?post=1419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}