I think this is a simple question but I am new to Gretl and keep trying things without success


I have data with variables and years as columns, and my rows are companies, so my data variables look like


Company name,ROE_year 1, ROE_year 2, ROE_year 3, ROE_year 4, Var2_year 1, Var2_year 2, Var2_year 3, Var2_year 4, Var3_year 1, Var3_year 2, Var3_year 3, Var3_year 4, Etc.


I thought I could read this as crossectional panel data, but it doesn’t work.  I know I can read in stacked time series, but the data doesn’t come in that format and involves a lot of manual changing.  My question is therefore can I do something with this data that is straightforward?  I will need to teach it to students, so I need to make it as easy as possible.


Thank you for any help you can give me




Alison Loddick


Learning Development Tutor (Mathematics and Statistics)

Library and Learning Services

DDI +44 (0)1604 893502





University of Northampton, Waterside Campus,

University Road, Northampton, NN1 5PH United Kingdom




University of Northampton: Transforming Lives and Inspiring Change www.northampton.ac.uk This e-mail is private and may be confidential and is for the intended recipient only. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in it. We virus scan all E-mails leaving The University of Northampton but no warranty is given that this E-mail and any attachments are virus free. You should undertake your own virus checking. The right to monitor E-mail communications through our networks is reserved by us.


The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast, a leader in email security and cyber resilience. Mimecast integrates email defenses with brand protection, security awareness training, web security, compliance and other essential capabilities. Mimecast helps protect large and small organizations from malicious activity, human error and technology failure; and to lead the movement toward building a more resilient world. To find out more, visit our website.