Creating New Rows with Opposite Value of Existing Data

[vandecx17]

Sounds simple, but I am having a hard time finding a solution. I want to replicate the data I already have in my Excel so each current row is duplicated with the same exact information, but the opposite value. For example, row 2 has a -156 value. I would like to replicate row 2 with a value of +156 so they net to zero.

[LordNeilLord · Accepted solution]

Hey @vandecx17 

Presuming you wan to stack them you could take a new bracnh with a formula Amount *-1 then union this back with the original output