Excel grouping vertical text + more....

[StevenK]

I'm looking for some means of putting together a spreadsheet which is generated from a number of database query result sets (from a SQL Server database backend).

For example I want to list sales order lines for stock items.
However I ideally I want to set groups within the list of ordered stock. Unfortunately the stock file is not ordered in an appropriate way for me to be able to do this in one SQL query.
So I'm looking at running a query to produce each grouping as desired.

I've no problem running queries from an Excel spreadsheet - having these feed from parameters on this sheet.
Similarly I'm familiar with Macros to better organise / present the final output.

My problem is that I want the groupings to have a text line on the far left hand edge (with vertical text - going up) for the height of the number of cells in each group, so we might have something like:

(Vertical)
Group 1 Order Line 1
.. Order Line 2
.. Order Line 3
.. Order Line 4

(blank line)
Group 2 Order Line 5
.. Order Line 6

, etc.
So my Group 1 is produced from one database query, my group 2 is produced from another, etc.

How can I do this in Excel via queries?
Such that I have these groupings - with the text 'Group 1' / 'Group 2', etc. running vertically?

Any help or pointers would be appreciated.

Thanks in advance.
Steve

 

[SkipVought]

Check my post to your question in forum68.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}