I have a data the below below format
Code | Company Name | Item | 2019 |
DIN | DIN Limited | Annual Balance Sheet - Total Equity | 16,925,931.00 |
DIN | DIN Limited | Annual Balance Sheet - NCA PP&E | 135,487.00 |
DIN | DIN Limited | Annual Balance Sheet - NCA Intangibles(ExGW) | 5,109,045.00 |
DIN | DIN Limited | Annual Balance Sheet - NCA Goodwill | 0.00 |
DIN | DIN Limited | Annual Profit and Loss - Reported NPAT After Abnorma | -4,270,815.00 |
DIN | DIN Limited | Annual Profit and Loss - Total Revenue Excluding Int | 60,273.00 |
DIN | DIN Limited | Annual Profit and Loss - Shares Outstanding at Perio | 172,389,923.00 |
DIN | DIN Limited | Annual Ratio Analysis - Market Cap.($) | 50,855,027.28 |
I would like to convert to a wide format as shown below
Code | Company Name | Annual Balance Sheet - Total Equity | Annual Balance Sheet - NCA PP&E | Annual Balance Sheet - NCA Intangibles(ExGW) | Annual Balance Sheet - NCA Goodwill | Annual Profit and Loss - Reported NPAT After Abnorma | Annual Profit and Loss - Shares Outstanding at Perio | Annual Ratio Analysis - Market Cap.($) |
DIN | DIN Limited | 16,925,931.00 | 135,487.00 | 5,109,045.00 | 0.00 | -4,270,815.00 | 172,389,923.00 | 50,855,027.28 |