Hi Expert,
Im learning excel while I work on parsing large amount data. Need your help me to create a new table from old table as listed below. Your help is highly appreciated. Thank you once again in advance for your great help,
Sincerely
Zi
<tbody>
</tbody>
Im learning excel while I work on parsing large amount data. Need your help me to create a new table from old table as listed below. Your help is highly appreciated. Thank you once again in advance for your great help,
Sincerely
Zi
Source Table | |||||||||||
Order_Aging | Company | Order Date | Order | Order Due Date | Amount | ||||||
1 - 30 | All-Good | 12/11/2018 | 1234 | 12/11/2018 | 2400 | ||||||
31 - 60 | All-Good | 11/26/2018 | 1200 | 11/26/2018 | 7200 | ||||||
Current | UC-Tower | 12/21/2018 | #40 | 12/31/2018 | 1100 | ||||||
1 - 30 | UC-Tower | 12/7/2018 | 135 | 200 | |||||||
- 90 | UC-Tower | 12/7/2018 | #38 | 12/17/2018 | 100 | ||||||
> 90 | UC-Tower | 12/21/2018 | 136 | 15000 | |||||||
current | Hello.com | 12/17/2018 | #7657 | 1/16/2019 | 90 | ||||||
current | Hello.com | 12/31/2018 | 72 | 1/10/2019 | 100 | ||||||
New Table | |||||||||||
Order_Aging | Company | Order Date | Order | Order Due Date | Current | 1 - 30 | 31 - 60 | 61 - 90 | > 90 | Amount | |
1 - 30 | All-Good | 12/11/2018 | 1234 | 12/11/2018 | 2400 | 2400 | |||||
31 - 60 | All-Good | 11/26/2018 | 1200 | 11/26/2018 | 2400 | 2400 | |||||
current | UC-Tower | 12/21/2018 | #40 | 12/31/2018 | 1100 | 1100 | |||||
1 - 30 | UC-Tower | 12/7/2018 | 135 | 200 | 200 | ||||||
61 - 90 | UC-Tower | 12/7/2018 | #38 | 12/17/2018 | 100 | 100 | |||||
> 90 | UC-Tower | 12/21/2018 | 136 | 15000 | 15000 | ||||||
current | Hello.com | 12/17/2018 | #7657 | 1/16/2019 | 90 | 90 | |||||
current | Hello.com | 12/31/2018 | 72 | 1/10/2019 | 100 | 100 | |||||
<tbody>
</tbody>