Converting Eurostat data in Stata data

[Ivan Nardini]

Hi!

I have this database:

It has one table for each value of n_person, i.e., it has 6 tables.

I want to convert this data format in panel data format (see 1 Photo)?

Thanks for the attention.

[Carlo Lazzaro]

Ivan:
this forum is for practisng purposes only.
If your goal is to get helpful replies about your query, please re-post on the General forum (avoiding screen-shot attachments, as they are difficult to read, please. See the FAQ on this and other topics concerning effective posting. Thanks).
That said, I would recommend you to take a look at -reshape-.

[Ivan Nardini]

Thanks Carlo for the advice