C
Colin
I've created an OLE DB Query that returns data from a SQL Server. I'd like
the data to appear in a pivot table the same way it appears when I run the
SQL query from Management Studio.
For example the data isn't grouped in SQL Query which is how I want it.
Project_ID | Resource | Hours
ProjectA | Bob | 8
ProjectA | Bob | 3
ProjectA | John | 5
ProjectB | John | 4
In excel I can't get my results to show like that. Instead I get the
following:
ProjectA | Bob | 8
| |3
| John | 5
ProjectB | John | 4
It groups the data for the columns. I'd like the data for the columns to
appear in every row so I can use this table in vlookups. Instead I get blank
cells because the data has been grouped together and is collapsible. How can
I get my SQL query to show properly in excel?
the data to appear in a pivot table the same way it appears when I run the
SQL query from Management Studio.
For example the data isn't grouped in SQL Query which is how I want it.
Project_ID | Resource | Hours
ProjectA | Bob | 8
ProjectA | Bob | 3
ProjectA | John | 5
ProjectB | John | 4
In excel I can't get my results to show like that. Instead I get the
following:
ProjectA | Bob | 8
| |3
| John | 5
ProjectB | John | 4
It groups the data for the columns. I'd like the data for the columns to
appear in every row so I can use this table in vlookups. Instead I get blank
cells because the data has been grouped together and is collapsible. How can
I get my SQL query to show properly in excel?