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%