Transform tools - having troubles

Question

I've tried cross tab tool which i believe is tool I should use but i am having a hard time trying to achieve what i want. I have the below data set.

Output OptionPageRegionRowRow_Tile_NumNameValueAlteryx table1Share Summary51Column 3                 79.13Alteryx table1Share Summary51Column 4            1,340.00Alteryx table1Share Summary51Column 5                        -  Alteryx table1Share Summary51Column 6                 79.13Alteryx table1Share Summary51Column 7            1,234.66Alteryx table1Share Summary51Column 8          97,692.42Alteryx table1Share Summary51Column 9                  (0.08)Alteryx table1Share Summary72Column 3                 58.60Alteryx table1Share Summary72Column 4            1,340.00Alteryx table1Share Summary72Column 5                        -  Alteryx table1Share Summary72Column 6                 58.60Alteryx table1Share Summary72Column 7            1,234.66Alteryx table1Share Summary72Column 8          72,347.13Alteryx table1Share Summary72Column 9                  (0.08)Alteryx table2Share Summary51Column 3               852.71Alteryx table2Share Summary51Column 4            1,340.00Alteryx table2Share Summary51Column 5                        -  Alteryx table2Share Summary51Column 6               852.71Alteryx table2Share Summary51Column 7            1,234.66Alteryx table2Share Summary51Column 8    1,052,802.38Alteryx table2Share Summary51Column 9                  (0.08)Alteryx table3Share Summary51Column 3               409.76Alteryx table3Share Summary51Column 4            1,341.77Alteryx table3Share Summary51Column 5                        -  Alteryx table3Share Summary51Column 6               409.76Alteryx table3Share Summary51Column 7            1,236.29Alteryx table3Share Summary51Column 8       506,583.38Alteryx table3Share Summary51Column 9                  (0.08)

Here is the desired format. What can i do to achieve this - is there another tool other than cross tab tool? any help/tips appreciated - thanks in advance!

Output OptionPageRegionRowRow_Tile_NumValueValue 2Value 3Value 4Value 5Value 6Value 7Alteryx table1Share Summary51       79.13  1,340.00              -         79.13  1,234.66        97,692.42        (0.08)Alteryx table1Share Summary72       58.60  1,340.00              -         58.60  1,234.66        72,347.13        (0.08)Alteryx table2Share Summary51       58.60  1,340.00              -         58.60  1,234.66        72,347.13        (0.08)Alteryx table3Share Summary51       58.60  1,340.00              -         58.60  1,234.66        72,347.13        (0.08)Alteryx table3Share Summary72     852.71  1,340.00              -       852.71  1,234.66  1,052,802.38        (0.08)Alteryx table4Share Summary51     409.76  1,341.77              -       409.76  1,236.29     506,583.38        (0.08)

adamweaver39 · Answer

Hi @RNSEG  -- could you please expand on the data set you are working with and the end goal for the transformation you are seeking to achieve?

Just looking at the input you have, versus the output you want, I don't see the data points lining up. So I am a little confused what you are going for here.

Also, if you can provide an excel file, it would be much easier to troubleshoot with you -- Thanks!