I have a table with the following structure:
month | cost_cat1 | cost_cat2 | cost_cat3
But I need this one:
month | cat | cost
In other words I need to convert a wide table to a long one.
I tried using the UNPIVOT command from SQL but I got an error.
Can anyone help me with this issue?
Thanks in advance !!