EViews.com

I have been using Eviews for years, but have only recently started working with large panel datasets. I am having a hard time figuring out a simple way to arrange an excel worksheet into the correct format for importing into Eviews for a panel data analysis. Any help would be greatly appreciated. The data looks like this:



i.e., data on Liabilities(Ls), Borrowings(Bgs), assets(Gfa), for 2 Companies (Corporations!) for 2001('01) & 2002('02) .

Please excuse me if this qs. has been asked/answered earlier- I am new to this forum. But I think others might also have encountered this problem, and this is the usual format for a database I will need to use a lot. (There is very probably a way with Pool objects etc, but I am not familiar with that at all :))

That particular format is incredibly difficult to work with. You'll need to write quite a complex EViews program to get that in nicely. You might be better off manipulating it in Excel to a more exportable-friendly structure.

Thanks, Gareth! Well, I managed to get the data into this format below, which looks better:
This should be manageable from here, but I am stuck for now!

Have you read the guide:
http://forums.eviews.com/viewtopic.php?f=7&t=74
?

Perfect- got it! Thanks a lot. :D Btw, this highlights how it would be great if Eviews had an online help facility- say linking to topics on this forum.