ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors