Skip to content

DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Fundamentals
  • Digital Marketing
    • WordPress
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
Menu

How to Transpose Data in Excel -2022’s Effortless

Posted on 13/05/202103/01/2022 by DigiRuns

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

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 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 transposed data (B) which is in detailed in the picture below.
Transposed data in Excel
difference between Data Table A and B in Excel
  • Following is the result of the Transposed data (B).
See also  How to Show or Hide Ink in Excel, Word, and Ppt
SN12345678910
First NameVaditheRajputhRajajiGaddelaBonalaSuryaChandraVayulaRajulaMaloth
Last NameOmkarShivaShambhoVishnuBalajiRamSomuNarayanaMalliJeshwanth
Roll Number54555657585960616263
ClassXXXXXXXXXX
SectionAAAAAAAAAA
Result of Transposed data

Other Amazing Articles:

  • How to Use Paste Link in Excel – 2021’s Light
  • Word Counter | Character Counter – All Tools- 2021
  • Top 10 Tricks to Shut Down, Restart, Sleep, etc. a Computer
  • How to Write a Perfect and SEO Friendly Blog Post 2021’s Challenge
  • No.1 Magical Shortcut Keys and Hidden Secrets in MS-Word
  • The Real Difference Between Functions and Formulas in Excel.
FAQ

What is Transpose in Excel?

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

See also  How to Use Total Formula in Excel - 2022's Secret

Recent Posts

  • How to Hide Featured Image On a WordPress Post/Page – 2022
  • YouTube Floating Window for Windows, Mac, and Mobiles
  • A Table Generator for Word and Office 360 – Shortcut Trick
  • How to Enable Missing Theme Editor and Plugin Editor in WP
  • (A-Z) Change Text Direction (Rotate, Flip or Mirror) in Word
  • How to Select Objects That are Behind Text in Word – 2022