create new column with existing data

[rojan]

Hi,

I  have a question regarding below table. Kindly need a help to resolve it

Existing table

account	value in US
50001	-200
50002	200
3000	-500
4500	500
45001	600
3000	-600

 how i can create desired below output from above table. account from Minus amount should come first corresponding second account positive and amount

account	sec account	currency
50001	50002	-200
3000	4500	-500
3000	45001	-600

[PhilippK · Accepted solution]

Hi @rojan,

please find my solution attached:

Is that the solution you were looking for?

Best regards 

Phil