Transposing data as it is being returned from an query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose Row by Row 5
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? 2
Transpose to Non-adjacent Cells 2
VB code for copying entire rows from mulitple worksheets into a worksheet 0
Copying Filtered Data from multiple worksheets 3
A better Macro for Copying Data 2
Data-Transpose Problem 1
Macro runs fine from VBEditor, but not button 22

Back
Top