The concatenate command -

[topshelfbleu]

Hi

I have a table that looks like

 

userid  qnum1  qnum2 qnum 3

1              a          b        c

2              d            a        f

 

I want to create a new table using this data but organised in a different format  i.e.

Answers

"userid","columnamefrom table1", "answer"

 

So this would look like

 

Answers

1;1;a

1;2;b

1;3;c

2;1;d

2;2;a

2;3;f

 

Is concatenate the way to go here?

 

 

 

 

 

 

 

[trq]

Both of these designs stink. You would be best having a table for users, a table for questions, then another table that joins users with questions and answers.