Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposing data as it is being returned from an query
Hi..
I am quering an oracle table which returns 1 row of 5 data elements. I want to display it horizontally (say in cells A1:A5). I know I can transpose it but I was wondering if there was a way I could do the conversion to a vertical list without having to first put it somewhere on the worksheet and then doing the transpose operation? I apologize for being such a rookie but your help would greatly be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposing data as it is being returned from an query
You could transpose an array that you got from the recordset with GetRows.
Or you could transpose the recordset itself, although that might be a bit more tricky then transposing the array. Principle will be the same for both, just loop through the array or recordset, swapping elements. Note that an array produced by GetRows is already transposed compared to the database source data. RBS "hll" wrote in message ... Hi.. I am quering an oracle table which returns 1 row of 5 data elements. I want to display it horizontally (say in cells A1:A5). I know I can transpose it but I was wondering if there was a way I could do the conversion to a vertical list without having to first put it somewhere on the worksheet and then doing the transpose operation? I apologize for being such a rookie but your help would greatly be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query returned more data than will fit on a worksheet | Excel Worksheet Functions | |||
Query returned more data than will fit on a worksheet | Excel Discussion (Misc queries) | |||
This query returned no data | Excel Worksheet Functions | |||
Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
The Web query returned no data | Excel Programming |