Rows to columns query

Database

Rows to columns query

Hi,

My table looks like

column name sort 

RAM    A   1

RAM    B    2

SHAM  C    NULL

DHAM  D    5

KIRU   E      6

MALA   F     7

MALA   G     8

Now i wan results like

column name sort  superscript 

RAM    A   1     1,2 

RAM    B    2     

SHAM  C    NULL  

DHAM  D    5      3

KIRU   E      6     4

MALA   F     7      5,6

MALA   G     8      

Tags (1)
2 REPLIES

Re: Rows to columns query

Any suggestions??

Re: Rows to columns query

it would help if your data made sense.  For example, in your desired results, you have RAM A 1 1,2 where does the 2 in the last column come from?  there isn't another RAM A row in your sample data.  please clarify.