Transpose Query Results

[doco]

Is there a way to have an MS Query resultset across columns instead of down rows?

I have a parameterized query that is going to return a fixed resultset of one record and I would like it to be displayed across columns insead of as a list in one column.

TIA

 

[ravishankar]

Hi
if your query output is a constant range then add these codes

range("A5:A30").copy
Range("B1").PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
        , Transpose:=True

Change A5 to A30 to fit your range and B1 to where you want the list started. Run the macro
Ravi

 

[doco]

Thanks. I am aware of the paste special process just not clear on how, or what would trigger the code after the Get External Data query finished and what effect if any this would have on rows of data below. Guess I will play around with the idea some.

So this code then would be run from a _Change() event?

Thanks again.