05-11-2011, 07:27 PM
It works using one sql query: "TRANSFORM SUM(b) SELECT a FROM [test$] GROUP BY a PIVOT FORMAT(c,'Short Date')"
|
sql in excel
|
|
« Next Oldest | Next Newest »
|
| Messages In This Thread |
Users browsing this thread: 2 Guest(s)