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.
@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
HI,
I like this Make Columns tool.
How can I add this in my toolbar?
Regards,
Johan
