Moving excel database from column to row based

So… I have a database in Excel, the structure is:

"Country" "Year" "Index1" "Index2" "Index3"...

"Italy" "2016" "1.3" "2.3" "8.5"

"Italy" "2015" "1.5" "2.9" "3.5"

"Italy" "2014" "1.8" "2.3" "4.5"

(” ” means separate column)

  • How to preview or display or edit an Excel file on web page by C# and .NET framework
  • Use Range Find Method in a specific column
  • VBA Excel code using echo y with PLink
  • find size of external monitor in excel vba
  • Excel offset formula, making calculation with unspecified vertical number
  • Password Cracker of Protected Sheet in Excel using VBA
  • i.e. each row contains in separate columns a country and year as well as all the descriptive parameters(Indexes) for the specific country and year.

    This is not very good for pivot tables, I think. So what I want to have is this:

    "Country" "Year" "Index name" "Index value"
    "Italy" "2016" "Index1" "1.3"
    "Italy" "2016" "Index2" "2.3"

    Do you now what I mean? Now, this could be very easy copy&aste… however my database has about 30 indexes for all countries in the world… for the past 30 years… hell of a database, no way I can do this via copy&paste…

    Any suggestions?

  • Excel - searching in database output (INDEX? VLOOKUP? MATCH?)
  • excel macro: storing values from one sheet in another if values don't exist, overwrite if they do
  • How to import MS Access records into Excel from a primary table and two linked tables?
  • Cannot append data to MySQL table when moving data from excel to MySQL workbench
  • Missing data when importing Excel file into DataGridView
  • extract data from multiple text files in a folder into excel worksheet
  • MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.