keizerkarel
New Member
- Joined
- Jun 25, 2018
- Messages
- 2
Hello,
We use accounting software from a big, reputable vendor. They offer Excel exports, but really don't know how to make them proper. What it looks like is shown below. The problem is the multiple-row layout.
How would I go about to fix this to a normal structure of 1 entry per row? It's not really possible to recreate this with the forum tables, and I'm not allowed to post attachments, so I tried to make it as clear as possible below. Screenshot is the current situation, table below is the ideal scenario:
Problem
Solution
<tbody>
</tbody>
Thanks in advance!!!
We use accounting software from a big, reputable vendor. They offer Excel exports, but really don't know how to make them proper. What it looks like is shown below. The problem is the multiple-row layout.
How would I go about to fix this to a normal structure of 1 entry per row? It's not really possible to recreate this with the forum tables, and I'm not allowed to post attachments, so I tried to make it as clear as possible below. Screenshot is the current situation, table below is the ideal scenario:
Problem
Solution
Description | Invoice Number | Type | Order Number | Discount | Ordered by | Discount date | Invoice for | Value | Amount | Invoice Date | File | Track status |
Description for invoice 1 | I20180001 | Normal | O20180001 | 0,00 | O000001 | O000001 | Eur | 123456,78 | 05-11-2018 |
<tbody>
</tbody>
Thanks in advance!!!