12 columns => 2 columns (SQL command or Unpivot?)

[flpnevs]

Hello!!!

I have a table connected to SQL that outputs a column for each month.
For working it better in Excel, I need to transforme that 12 columns to only 2... a first one for the values and the second for the respective month (that at this moment are the column titles).

In your opinion, which will be the better option (or if it dependes, advantages and desavantages):
a) a SQL command (not familiar to me);
b) use unpivot in Query Edit

 

[flpnevs]

See if this helps
Excel Tips From John Walkenbach: Creating A Database Table From A Summary Table

scroll down and you see a link to a macro

M.

Thank you again, but again... output is exactly that, but I need something that is always ready. I rather use unpivot in Query Edit.

But even more, I prefer unpivot in SQL, but I don't have the knowledge.