Hélio, I'm afraid this won't work with such a data structure.Just try to Open the file. Then the importer will start.
On Wed, Jun 12, 2019 at 10:55 AM <dado.marchello@fastwebnet.it> wrote:
Good morning, I am trying to import a panel data variable from excel in which I have in the first row all the entities and in the first column all the dates. How can I do that
There's something in the user guide (pdf from the help menu) that
deals with such a situation: It's the unnumbered subsection "Panel
data arranged by variable" in section 4.5 Panel data specifics.
Basically, gretl has a very special function 'stack' to achieve
that.
I don't think you can do this via the GUI yet, you have to script it (but the guide has examples). Because the stack function is so special (and admittedly somewhat weird) work has started to replace it with something more user-friendly; see this tracker item: https://sourceforge.net/p/gretl/feature-requests/115/
However, this is not ready yet (I wish I could find some time for finishing it...). One quick-and-dirty graphical workaround could be to cut-and-paste the entities in your Excel file below each other (so stacking them manually - assuming N << T). Then when it asks you you tell the gretl importer that you have a stacked time series structure and then how many time periods T. N will be inferred automatically.
HTH,
sven