I want to separate the values in one column into separate columns so that the negative values will be on one column and the positive in one column. see sample dataset below
| Column A | Amount |
|---|---|
| revenue | 2300 |
| expenses | -1990 |
| revenue | 100 |
| revenue | 1093 |
| expenses | -299 |
I want to separate the values in one column into separate columns so that the negative values will be on one column and the positive in one column