DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Windows Computer
    • Fundamentals
  • Digital Marketing
    • WordPress
    • Online Tools
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
  • HTML Sitemap
  • Contact us
Menu
Select and Copy Data

How to Transpose Data in Microsoft Excel -2022

Posted on 13/05/202106/09/2023 by DigiRuns

Transpose data means changing the row data to column data, or vice versa. This option is a part of the paste special in Excel.

Table of Contents

Steps to Transpose Data:
What is Transpose in Excel?
Can I transpose data between different worksheets or workbooks in Excel?
What happens to formatting when I transpose data in Excel?
Can I transpose data that includes formulas in Excel?
How do I undo a data transpose operation if I make a mistake?

Steps to Transpose Data:

For example, suppose you have the following data which is related to students’ details.

SNFirst NameLast NameRoll NumberClassSection
1VaditheOmkar54XA
2RajputhShiva55XA
3RajajiShambho56XA
4GaddelaVishnu57XA
5BonalaBalaji58XA
6SuryaRam59XA
7ChandraSomu60XA
8VayulaNarayana61XA
9RajulaMalli62XA
10MalothJeshwanth63XA
Student Details

Select and copy the data.

Select and Copy Data
Select and Copy Data

Now to transpose copied data (change data from column to row or vice versa) wherever you want, right-click at the blank area of the worksheet and click paste special or use the shortcut key (ctrl+alt+v) to open a dialogue box.

After opening the dialogue box, checkmark the Transpose and click OK.

Open Transpose dialogue box
Open a dialogue box

You can see the difference between the copied data (A) and relocated data (B) which is in detail in the picture below.

Transposed data in Excel
difference between Data Table A and B in Excel

Following is the result of the relocated data (B).

SN12345678910
First NameVaditheRajputRajajiGaddelaBonitaSuryaChandraVayulaRajulaMaloth
Last NameOmkarShivaShambhoVishnuBalajiRamSomuNarayanaMalliJeshwanth
Roll Number54555657585960616263
ClassXXXXXXXXXX
SectionAAAAAAAAAA
Result of Transposed data
Frequently Asked Questions:

What is Transpose in Excel?

It means to change the row data to a column or row or vice versa. This is an easy trick to change the data layout horizontally or vertically.

Can I transpose data between different worksheets or workbooks in Excel?

Yes, you can copy data from one worksheet or workbook, navigate to the target location, and use the “Transpose” option to paste it.

What happens to formatting when I transpose data in Excel?

Formatting remains intact when you transpose data using the “Transpose” option, ensuring consistency in appearance.

Can I transpose data that includes formulas in Excel?

Yes, you can transpose data with formulas, and Excel will adjust the formulas accordingly to match the new orientation.

How do I undo a data transpose operation if I make a mistake?

You can use the “Undo” feature (Ctrl + Z) to reverse the transpose operation and restore the original data layout.

Category: Microsoft Excel

Recent Posts

  • 11 Paraphrasing Tools to Improve Content Quality
  • The Best PDF File Converters (Free and Easy-to-Process)
  • Examining Binary Translators Uses in the Real World – 2023
  • Free Online Tools for Writing Blog Content in 2023
  • Computer Acronyms and Abbreviations: A Complete List – 2023
© 2023 DigiRuns | Powered by Minimalist Blog WordPress Theme