I have 3 txt files with sample Content as below
File 1:
Report Generated Time: 01-02-2021 21:02:10
Total Number of Laptops Reporting Count:10000
Laptops Authorized Count:10001
Laptop(s) Authorization Pending Count:10002
Laptop(s) Duplicate Pending Deactivation:10003
Laptop(s) Newly added since last 24 Hours:10004
Laptop(s) NOT Communicated Since last 45 Days:10005
File 2:
Report Generated Time: 02-02-2021 21:03:14
Total Number of Laptops Reporting Count:20000
Laptops Authorized Count:20001
Laptop(s) Authorization Pending Count:20002
Laptop(s) Duplicate Pending Deactivation:20003
Laptop(s) Newly added since last 24 Hours:20004
Laptop(s) NOT Communicated Since last 45 Days:20005
File 3:
Report Generated Time: 03-02-2021 21:02:34
Total Number of Laptops Reporting Count:30000
Laptops Authorized Count:30001
Laptop(s) Authorization Pending Count:30002
Laptop(s) Duplicate Pending Deactivation:30003
Laptop(s) Newly added since last 24 Hours:30004
Laptop(s) NOT Communicated Since last 45 Days:30005
Objective is to merge contents in all 3 files to create a master txt file with format as below:
Can someone advise please.
| Description | 3/2/2021 | 2/2/2021 | 1/2/2021 |
| Total Number of Laptops Reporting Count | 30000 | 20000 | 10000 |
| Laptops Authorized Count | 30001 | 20001 | 10001 |
| Laptop(s) Authorization Pending Count | 30002 | 20002 | 10002 |
| Laptop(s) Duplicate Pending Deactivation | 30003 | 20003 | 10003 |
| Laptop(s) Newly added since last 24 Hours | 30004 | 20004 | 10004 |
| Laptop(s) NOT Communicated Since last 45 Days | 30005 | 20005 | 10005 |