General Discussions

Discuss any topics that are not product-specific here.

How to turn row headers into column

SamyamL
5 - Atom

IMG_8025.jpeg

Please see the picture above. Trying to go from the first table to something like the second!

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @SamyamL you can use a transpose tool to achieve the desired results.

 

Transpose_20012024.JPG

 

 

marcoperson250
6 - Meteoroid

In Excel turn the row header into columns

  • First select the row header then copy the data 
  • Rights click other location then select paste special
  • Then choose transpose 
  • In SQL use pivot clase to convert row header to column.
  • I hope this is helpful for you.

Thank you for asking this question I forgot some formula in Excel but after seeing your question I revised  the Excel formula and another shortcut also.https://community.alteryx.com/t5/General-Discussions/python training in coimbatoreHow-to-turn-row-headers-into-column/td-p/1231148

 

Labels