Dear all,

I have a problem in Stata that I have been struggling with for quite some time now.
As you can see in the screenshot I have a database whereby I have a variable 'Item' which includes seven characteristics belonging to a certain company in a certain year (such as employees, sales, profit etc). I have a seperate variable called 'value' whereby the value of these Item variables is displayed. I however want to have my dataset in the form whereby the Item characteristics are seperate variables, and their values are displayed for every company observation in the given year.

I have tried to transform my data, but I cannot get the values of the Item characteristics displayed for all years of the company, but only for when the 'Item' equals the certain characteristic (see screenshot).

Can someone help me with a command or way to get this right?

Thank you very much in advance.

Kind regards,
Nathalie