Reply With Quotein sql you can
item + ' ' + item
you apply your sequence with
ORDER BY
10, 4 5, 7
Thanks: 0
Likes: 0
12 columns => 2 columns (SQL command or Unpivot?)
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
Re: 12 columns => 2 columns (SQL command or Unpivot?)
in sql you can
item + ' ' + item
you apply your sequence with
ORDER BY
10, 4 5, 7
Last edited by mole999; Mar 14th, 2017 at 02:27 AM.
- Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
- I wear my ignorance openly, excel is not my chosen career, its a means to an ends
- Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
Code:[CODE ]Put Your Code[/ CODE]- Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
- X-Posting Guidelines Rule 13 > CHART STUFF
Re: 12 columns => 2 columns (SQL command or Unpivot?)
Maybe this can help
https://www.youtube.com/watch?v=xmqTN0X-AgY
M.
Re: 12 columns => 2 columns (SQL command or Unpivot?)
But that will sum all the values, correct? I still need the values for each month, so one row with JAN, FEV (...) NOV e DEZ will become twelve lines (I exchange clumns by rows)Originally Posted by mole999
Re: 12 columns => 2 columns (SQL command or Unpivot?)
Thank you.
The output is exactly that, but I need something more dynamic, since it will be something used monthly.
Re: 12 columns => 2 columns (SQL command or Unpivot?)
no sum. it would bring together fields with a space
- Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
- I wear my ignorance openly, excel is not my chosen career, its a means to an ends
- Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
Code:[CODE ]Put Your Code[/ CODE]- Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
- X-Posting Guidelines Rule 13 > CHART STUFF
Re: 12 columns => 2 columns (SQL command or Unpivot?)
You should be able to use SQL to transpose columns/rows, perhaps using UNPIVOT.
If posting code please use code tags.
Re: 12 columns => 2 columns (SQL command or Unpivot?)
But I do not want all field in only one cell. I want them in different cells, but horizontally.
(sorry in I do not understand correctly)
Re: 12 columns => 2 columns (SQL command or Unpivot?)
I was trying to use UNPIVOT in SQL, but my poor knowledge don't allow me. Do you have any example that I can use?
Re: 12 columns => 2 columns (SQL command or Unpivot?)
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.
Last edited by Marcelo Branco; Mar 14th, 2017 at 05:05 PM.
Like this thread? Share it with others