I have a table with data like this:
a | b | c | d | e
1 | 2 | 3 | 4 | 5
and I want it to be:
name | value
a | 1
b | 2
c | 3
d | 4
e | 5
thank you for your help!
Asked
Active
Viewed 26 times
0
aspp
- 21
- 2
-
1you can use union all, but this is not dynamic. – glovemobile Mar 03 '21 at 10:52
-
I am trying to avoid union all because then I have to run a query for each name. – aspp Mar 03 '21 at 10:53
-
1Does this answer your question? [Transposing Dynamic Columns to Rows](https://stackoverflow.com/questions/16359345/transposing-dynamic-columns-to-rows) – glovemobile Mar 03 '21 at 11:03
-
I think that yes – aspp Mar 03 '21 at 11:15