How to turn row headers into column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SamyamL
5 - Atom
‎01-19-2024
02:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please see the picture above. Trying to go from the first table to something like the second!
Labels:
- Labels:
- Alteryx Practice
2 REPLIES 2
17 - Castor
‎01-20-2024
06:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
marcoperson250
6 - Meteoroid
‎01-21-2024
09:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
