SOLVED
Report table tool
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
knozawa
11 - Bolide
‎03-27-2017
02:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am using a report tool (Table) to create PowerPoint. I have one Name and one Value fields. Is there anyway to create three columns with only values?
Example:
Raw data
Name | Value |
A | 1 |
B | 2 |
C | 3 |
D | 4 |
E | 5 |
F | 6 |
G | 7 |
H | 8 |
I | 9 |
Desired Output:
1 | 5 | 9 |
2 | 6 | 10 |
3 | 7 | |
4 | 8 |
Sincerely,
knozawa
Solved! Go to Solution.
Labels:
- Labels:
- Tips and Tricks
3 REPLIES 3
MSalvage
11 - Bolide
‎03-27-2017
04:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@knozawa,
Definitely not the most elegant solution, but I think it should get the job done. I did not find a way to use the Report(table) tool to do this so i just reorganized the data using other tools.
Note: You may have to do some sorting to get it in the order you want.
Good Luck,
MSalvage
AdamR_AYX
Alteryx Alumni (Retired)
‎03-28-2017
01:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JohanRanschaert
8 - Asteroid
‎05-22-2020
07:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI,
I like this Make Columns tool.
How can I add this in my toolbar?
Regards,
Johan
