Forum Discussion
Attaching a file to a discussion thread
I'm trying to write up a discussion for a sheet I'm working on, but when I try to drop and drop the .xlsx file to the editor, it says it isn't supported. I've tried a number of file types and they al...
Maybe you can copy and paste your data along with the expected result into your post. This way community members can copy your data and paste it into an Excel sheet.
Data:
| name | date | netto | tax | fees | total |
| client1 | 20.07.2022 | 400 | 25 | 5 | 430 |
| client1 | 21.07.2022 | 700 | 20 | 15 | 735 |
| client2 | 22.07.2022 | 400 | 35 | 10 | 445 |
| client2 | 23.07.2022 | 600 | 600 | ||
| client2 | 20.07.2022 | 800 | 25 | 825 | |
| client3 | 21.07.2022 | 1000 | 20 | 15 | 1035 |
| client3 | 22.07.2022 | 200 | 35 | 235 | |
| client4 | 23.07.2022 | 400 | 400 | ||
| client4 | 20.07.2022 | 400 | 25 | 5 | 430 |
| client5 | 21.07.2022 | 400 | 20 | 15 | 435 |
| client5 | 22.07.2022 | 100 | 35 | 10 | 145 |
| client6 | 23.07.2022 | 100 | 25 | 125 | |
| client6 | 20.07.2022 | 200 | 25 | 5 | 230 |
| client6 | 21.07.2022 | 600 | 20 | 15 | 635 |
| client7 | 22.07.2022 | 900 | 35 | 935 | |
| client7 | 23.07.2022 | 800 | 25 | 20 | 845 |
| client8 | 20.07.2022 | 600 | 600 | ||
| client8 | 21.07.2022 | 700 | 20 | 15 | 735 |
| client9 | 22.07.2022 | 400 | 400 | ||
| client9 | 23.07.2022 | 700 | 25 | 20 | 745 |
| client10 | 20.07.2022 | 1000 | 25 | 1025 | |
| client10 | 21.07.2022 | 300 | 20 | 15 | 335 |
| client10 | 22.07.2022 | 200 | 35 | 235 | |
| client11 | 23.07.2022 | 200 | 200 | ||
| client11 | 20.07.2022 | 100 | 25 | 5 | 130 |
| client12 | 21.07.2022 | 200 | 20 | 220 | |
| client12 | 22.07.2022 | 300 | 35 | 10 | 345 |
Expected result:
| client1 | 20.07.2022 | 400 | 430 | ||
| client1 | 20.07.2022 | 25 | 430 | ||
| client1 | 20.07.2022 | 5 | 430 | ||
| client1 | 21.07.2022 | 700 | 735 | ||
| client1 | 21.07.2022 | 20 | 735 | ||
| client1 | 21.07.2022 | 15 | 735 | ||
| client2 | 22.07.2022 | 400 | 445 | ||
| client2 | 22.07.2022 | 35 | 445 | ||
| client2 | 22.07.2022 | 10 | 445 | ||
| client2 | 23.07.2022 | 600 | 600 | ||
| client2 | 20.07.2022 | 800 | 825 | ||
| client2 | 20.07.2022 | 25 | 825 | ||
| client3 | 21.07.2022 | 1000 | 1035 | ||
| client3 | 21.07.2022 | 20 | 1035 | ||
| client3 | 21.07.2022 | 15 | 1035 | ||
| client3 | 22.07.2022 | 200 | 235 | ||
| client3 | 22.07.2022 | 35 | 235 | ||
| client4 | 23.07.2022 | 400 | 400 | ||
| client4 | 20.07.2022 | 400 | 430 | ||
| client4 | 20.07.2022 | 25 | 430 | ||
| client4 | 20.07.2022 | 5 | 430 | ||
| client5 | 21.07.2022 | 400 | 435 | ||
| client5 | 21.07.2022 | 20 | 435 | ||
| client5 | 21.07.2022 | 15 | 435 | ||
| client5 | 22.07.2022 | 100 | 145 | ||
| client5 | 22.07.2022 | 35 | 145 | ||
| client5 | 22.07.2022 | 10 | 145 | ||
| client6 | 23.07.2022 | 100 | 125 | ||
| client6 | 23.07.2022 | 25 | 125 | ||
| client6 | 20.07.2022 | 200 | 230 | ||
| client6 | 20.07.2022 | 25 | 230 | ||
| client6 | 20.07.2022 | 5 | 230 | ||
| client6 | 21.07.2022 | 600 | 635 | ||
| client6 | 21.07.2022 | 20 | 635 | ||
| client6 | 21.07.2022 | 15 | 635 | ||
| client7 | 22.07.2022 | 900 | 935 | ||
| client7 | 22.07.2022 | 35 | 935 | ||
| client7 | 23.07.2022 | 800 | 845 | ||
| client7 | 23.07.2022 | 25 | 845 | ||
| client7 | 23.07.2022 | 20 | 845 | ||
| client8 | 20.07.2022 | 600 | 600 | ||
| client8 | 21.07.2022 | 700 | 735 | ||
| client8 | 21.07.2022 | 20 | 735 | ||
| client8 | 21.07.2022 | 15 | 735 | ||
| client9 | 22.07.2022 | 400 | 400 | ||
| client9 | 23.07.2022 | 700 | 745 | ||
| client9 | 23.07.2022 | 25 | 745 | ||
| client9 | 23.07.2022 | 20 | 745 | ||
| client10 | 20.07.2022 | 1000 | 1025 | ||
| client10 | 20.07.2022 | 25 | 1025 | ||
| client10 | 21.07.2022 | 300 | 335 | ||
| client10 | 21.07.2022 | 20 | 335 | ||
| client10 | 21.07.2022 | 15 | 335 | ||
| client10 | 22.07.2022 | 200 | 235 | ||
| client10 | 22.07.2022 | 35 | 235 | ||
| client11 | 23.07.2022 | 200 | 200 | ||
| client11 | 20.07.2022 | 100 | 130 | ||
| client11 | 20.07.2022 | 25 | 130 | ||
| client11 | 20.07.2022 | 5 | 130 | ||
| client12 | 21.07.2022 | 200 | 220 | ||
| client12 | 21.07.2022 | 20 | 220 | ||
| client12 | 22.07.2022 | 300 | 345 | ||
| client12 | 22.07.2022 | 35 | 345 | ||
| client12 | 22.07.2022 | 10 | 345 |