Hello!
I'm new to this community so please forgive me if i'm posting this in the wrong place.
I have very row system download. There is "main rows" in this download, but data which also relates to this rows could be presented in rows after this main row. There are a lot of lines in download and document names, description and other information could be the same.
What I have:
| Date | Document | Description | Dt | Cr | Amount | Dt Details | Ct Details |
| 01.01.2020 | Document 1 | Description 1 | 2004 | 6001 | 250 000,00 | Other expenses | LLC B |
| | | | | | | Business Unit C | Agreement B #1 |
| | | | | | | | Invoice B #1 |
| 10.01.2020 | Document 2 | Description 2 | 6001 | 6002 | 100 000,00 | LLC A | LLC A |
| | | | | | | Agreement A #1 | Agreement A #1 |
| | | | | | | Invoice A #1 | |
| 13.03.2020 | Document 3 | Description 3 | 2004 | 6001 | 2 000,00 | Marketing expenses | LLC C |
| | | | | | | Business Unit B | Agreement C #1 |
| | | | | | | | Invoice C #1 |
| | | | | | | | Invoice Description |
What I need:
| Date | Document | Description | Dt | Cr | Amount | Dt Details 1 | Dt Details 2 | Dt Details 3 | Ct Details 1 | Ct Details 2 | Ct Details 3 | Ct Details 4 |
| 01.01.2020 | Document 1 | Description 1 | 2004 | 6001 | 250 000,00 | Other expenses | Business Unit C | | LLC B | Agreement B #1 | Invoice B #1 | |
| 10.01.2020 | Document 2 | Description 2 | 6001 | 6002 | 100 000,00 | LLC A | Agreement A #1 | Invoice A #1 | LLC A | Agreement A #1 | | |
| 13.03.2020 | Document 3 | Description 3 | 2004 | 6001 | 2 000,00 | Marketing expenses | Business Unit B | | LLC C | Agreement C #1 | Invoice C #1 | Invoice Description |
I'd appreciate any help. Thank you.
