423,682 Members | 1,327 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,682 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,272
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.