Here is my problem. So any feedback from you will be a greatly appreciated.
My data is like example below.

Account Debit credit
1222 12.00
1556 345.52
6689 45.63 45.63
5589 25.56
So the final data I like to see is as follows

I am using formula to put those data into another worksheet.(concatenate function)
I am using pipe as a delimiters to separate the data.

My issue is when no data on debit column I want to use |(pipe) on beginning and end of data like |345.52|
I am also using `1222` in all account column(` ` because text)

And when both column has data then I want to use pipe only end of the data like 45.63| 45.63|
So the final data I like to see is as follows

`1222`| 12.00|
`1556`| |345.52|
`6689`|45.63 |45.63|
`5589`|25.56 |

If there is blank no data then just nothing empty space "".
Thanks for your time.