Formatting Data

[DarioN]

Hello, I am relatively new to alteryx and was wondering if the desired output was possible within alteryx. I have transactions with a company, trading partner, and the account number. I want to essentially stack the other side of the entry underneath the current row. Please help if possible. 

[Raj]

@DarioN Yes, this is possible Please attach sample input and expected output.

[DarioN]

Hope this helps!

Current Input:

Comp.	TP	Acct Number	Amount	Amount
CP	TP	4000	0	100
CP	TP	4001	100	100
CP	QN	4000	200	100
CP	QN	4001	-200	200

Desired Output:

Comp.	TP	Acct Number	Amount	Amount
CP	TP	4000	0	100
CP	TP	4001	100	100
TP	CP	4000	100	100
TP	CP	4001	0	100

[DarioN]

Input:

Company | Trading Partner | Account Number | Amount | Amount

EX | TP | 4000 | ### | ### 

EX | TP | 4001 | ### | ###

EX | PT | 4000 | ### | ###

EX | PT | 4001 | ### | ### 

etc.

Desired Output: 

Company | Trading Partner | Account Number | Amount | Amount

EX | TP | 4000 | ### | ### 

EX | TP | 4001 | ### | ###

TP | EX | 4000 | ### | ###

TP | EX | 4001 | ### | ###

[Qiu]

@DarioN 
Can you eloborate a bit more?
I can not see the logic between your input and output..😂