1.) Can any of you give me good references of books about how to work efficient in Excel with emphasic on large dataset handling. 2.) I am merging several dataset into one data set and is confronting lots of "stupied" problems that mostly takes time. I am merging one data set to another. In the first data set call it X have 120 countries over a time period of 2000-2003. The second data set call it Y have the same selction of data set but for years 1997-1999 . Country Years Sweden 2000 Sweden 2001 Sweden 2002 Denmark 2000 Denmark 2002 Denmark 2003 When I merge with the data Y, I need to incert 3 rows above Sweden year 2000 and Denmark years 2000. Then I need to fill out the country name and years in the 3 rows. However, now I have 120 countries and a time period of over 10 years. Then incering 10 rows for each and every 120 countires and copy /past of all the country names and the time period it just a wast of time.
Find latest posts