Report table tool

knozawa

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

MSalvage

@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

3 Column Table Solution.yxmd

3 Column Test.xlsx