Transform Field to row

[Anonymous]

Hello,

I have data

I want to transform tagID from column to row

Please see my attached files.

Thanks,

[Anonymous]

If I use Generic LOAD, I have thounds tables.

[#3]

Explain better what you want !!

[Anonymous]

Each respondent has 2 rows. I want to have for each respondent all value in 1 row.

TO

If questionID=1, value of tagID should be in Field questionID1

If questionID=3, value of tagID should be in Field questionID3

Thanks,

[Anonymous · Accepted solution]

I got it

Generic

LOAD respondentID,    comeTime, 

    'question' &questionID,

    tagID;