unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hi Gurus,
Could possibly help me formulate the codes so I can get the results like the Clean Sheet?
I just need to get the data per account per month in descending order and will exclude those accounts with zero shares.
Raw sheet
<tbody>
</tbody>
Clean Sheet
<tbody>
</tbody>
Any help will be much appreciated.
Could possibly help me formulate the codes so I can get the results like the Clean Sheet?
I just need to get the data per account per month in descending order and will exclude those accounts with zero shares.
Raw sheet
Account | Name | Note | Mar-19 | Feb-19 | Jan-19 |
001 | 100 | 80 | 50 | ||
002 | 50 | 50 | 20 | ||
003 | 10 | 10 | 0 | ||
Total | 160 | 140 | 70 |
<tbody>
</tbody>
Clean Sheet
Account | Name | Qty |
03/30/2019 | 001 | 100 |
03/30/2019 | 002 | 50 |
03/30/2019 | 003 | 10 |
02/28/2019 | 001 | 80 |
02/28/2019 | 002 | 50 |
02/28/2019 | 003 | 10 |
01/31/2019 | 001 | 50 |
01/31/2019 | 002 | 20 |
<tbody>
</tbody>
Any help will be much appreciated.