423,323 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,323 IT Pros & Developers. It's quick & easy.

query to transpose row data into column

P: 1
i have result of query as below

Expand|Select|Wrap|Line Numbers
  1. CAJ74U    1    120131.82    3    H
  2. CAJ74U    2    261783.82    2    H
  3. CAJ74U    3    150373.57    1    H
  4. CAJ74U    4    140402.12    1    H
  5. CAJ74U    5    165292.85    1    H
  6. CAJ74U    6    196789.4    1    H
  7. CAJ74U    1    1352.62            3    L
  8. CAJ74U    2    1564.82            5    L
  9. CAJ74U    3    37444.57    2    L
  10. CAJ74U    4    3530.57            2    L
  11. CAJ74U    5    13966.3            4    L
  12. CAJ74U    6    22816.85    3    L
and i want results like
Expand|Select|Wrap|Line Numbers
  1. CAJ74U    1    120131.82    3    1352.62  CAJ74U    2    261783.82    2    1564.82
  2. CAJ74U    3    150373.57    1    37444.57
  3. CAJ74U    4    140402.12    1    3530.57
  4. CAJ74U    5    165292.85    1    13966.3
  5. CAJ74U    6    196789.4    1    22816.85
Jul 4 '18 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,248
Please use code tags when posting code or formatted data

I have no idea what you're trying to do, you have not explained your requirements clearly at all. Why are only some rows transposed and not the others? Why aare some rows filtered out?
Jul 4 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.