SOLVED
How to Transpose Single Row of Data
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
Gandalf_NotGrey
8 - Asteroid
‎07-11-2024
03:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, I have a row of data with four fields such as below -
Sum 1 | Sum 2 | Difference between Sum 1 and Sum 2 | Statement |
34 | 43 | 9 | Difference between Sum 1 and Sum 2 is 9 |
I want to convert this as shown below -
Sum 1 | 34 |
Sum 2 | 43 |
Difference between Sum 1 and Sum 2 | 9 |
Statement | Difference between Sum 1 and Sum 2 is 9 |
Is this possible in Alteryx?
Thanks so much in advance.
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Help
- Tips and Tricks
- Workflow
2 REPLIES 2
17 - Castor
‎07-11-2024
03:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Gandalf_NotGrey, if you just connect a Transpose tool and leave the configuration at the default (i.e. all columns ticked as Data Columns), that should do the job.
‎07-11-2024
03:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You @DataNath
