Transpose rows x columns

[mumaan]

Hello friends, I´m new here and I use Access for about 3 years already.
I use, not a very good programmer though. But I have started some self-learning on it and it´s been helping me a lot in work.
I have a doubt: how do I transpose Rows into Columns in Access?

I have for example the table(1).

I just want to transpose the values so it gets like table(2)

I have found several similar doubts, but usually they are more complex as to sum up rows or columns.


In my case is a simple transpose, because when I import the data from an excel spreadsheet I have to first enter on the sheet, transpose the data, and them work with it in Access. I want to create a button only to transpose that for me in the Access database . Is it possible?

Also, while transposing, would be possible to remove a future column, let´s say, Real Sector and Inflation? I already have a query doing that but if I could do all in one would be great.

Thank you all for the help!


(1)

Annual data	2014	2015	2016
Real sector
Population	203	203	203
GDP	5.521	5.521	5.328
Economic Growth	7%	7%	8%
Inflation	3%	4,50%	5%
Current account balance	-4%	-3,78%	-2,35%

(2)

Annual data	Real sector	Population	GDP	Economic Growth	Inflation	Current account balance
2014		203	5.521	7%	3%	-4%
2015		203	5.521	7%	4,50%	-3,78%
2016		203	5.328	8%	5%	-2,35%

[ranman256]

1. build a query that pulls the data you want.
2. now use the query wizard and select the query in 1, and make a CROSSTAB query. it will guide you for rows vs columns.