Help rearranging data for regression

[Harris Econ]

Dear all,

Attached is a PDF-file in which I describe the dataset and how I would like to rearrange it. I would appreciate any help! Thanks in advance.

Best,
Harris Econ

data.pdf

[Harris Econ]

Or simply view this image

[Nick Cox]

https://www.statalist.org/forums/help#stata explains about presenting data examples. Please do read and act on it.

Experienced users willingly spend time to tackle well-posed problems but are unwilling to carry out the surgery or engineering needed to convert images into decent examples such as you can and should give.

Econ is an interesting family name for what you do.