break rows into columns-cross tab

[EtamSoko]

hi guys,

I have the below dummy input and below that my desired output. In the process I got lost in Cross-tab tool. can you please help me to get to where I want to be? attaching my workflow.

item      price

112233  2
112233 10
4556     1
4556     5
4556    10

___

item      price1  price 2    price3   total

112233   2            10                      12

4556       1             5           10        16

TIA!

MKM

[atcodedog05 · Accepted solution]

Hi @EtamSoko 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[jdunkerley79 · Accepted solution]

I would suggest:

Use a multi-row formula tool to create a field going "Price1", "Price2" for each row resetting for each item

Use a summarise tool to make the totals

Use a union to join the two sets

Then a cross-tab will do what you want

Sample attached.

[grazitti_sapna · Accepted solution]

Hi @EtamSoko,

Here is my take on your problem.

I hope it helps.

[vizAlter · Accepted solution]

Hi @EtamSoko — "CrossTab" tool can give you the Totals as well. Try this solution:

If this solves your issue please mark the answer "Solved" with a Like, if not let me know!

[EtamSoko]

thank you all for the quick help! 

[vizAlter]

@EtamSoko — Thank you!

[atcodedog05]

Happy to help 🙂 @EtamSoko 

Cheers and Happy Analyzing 😀