Converting from Long format to Wide Format

Doe — Tue, 16 Feb 2021 09:40:03 GMT

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

Re: Converting from Long format to Wide Format

Rick_SAS — Tue, 16 Feb 2021 11:12:50 GMT

Please do not post the same question twice.

This is a duplicate of

and people are responding to the question in that forum.

Doe — Tue, 16 Feb 2021 11:23:00 GMT

Very well noted. Thanks