Sep 09 2022 04:22 AM
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 all seem to get rejected.
Any help?
Sep 09 2022 04:28 AM
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 |