How to stock up value

[mlozovskaya]

I have 3 separate summary columns A,B, and C

What steps should I take for my final result to look like example below?  I tried Union tool but I need to see data in the same row

A	-200
B	300
C	100

[Jonathan-Sherman · Accepted solution]

Hi @mlozovskaya,

You'll want to pivot your data using the transpose tool:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[mlozovskaya]

I have 3 separate values not stored together. I need to join them in the way they can be stocked on top of each other 

[Jonathan-Sherman · Accepted solution]

Hi @mlozovskaya,

You'll want to use the union tool in that case:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan