Transposing columns to rows in Excel

Question

I want to transpose my data in excel currently looks like this:

And it should look like this: 

You see the problem is that I do not only need to transpose the columns with values, but also add rows for each consecutive year for each indicator and for a given country. Any help?

Answer 1

Due to the amount of your data, we are unsure if you can achieve that based on your photographs. But I believe the TRANSPOSE(array) cell formula is what you need with some filtering and rearranging:

Here is what we'll get: 

---

• Select the destination range where you want to place your new/good data

• Enter =TRANSPOSE( into the formula bar

  

---

• Select the source range of your old/bad data (or type the address manually)

• Close the ) for the cell formula

  

• Hit Ctrl + Shift + Enter