Converting a single row to a column

[aniketsr]

Hi,

I have a scenario where the data is on the format below,

Qno	21	39	46	102
1A	Yes	Yes	Yes	Yes
1B	Yes	NO	Yes	Yes
1C	Yes	NO	NO	Yes
1D	Yes	NO	Yes	Yes

but we need to save the data in the Qvd in the below given format,

Qno	SrNo	Answers
1A	21	Yes
1A	39	Yes
1A	46	Yes
1A	102	Yes
1B	21	Yes
1B	39	NO
1B	46	Yes
1B	102	Yes

Kindly help me wid the same

[tresesco]

Have a look at CROSSTABLE() functionality.

[MayilVahanan]

HI

Try like this

Crosstable(SrNo,Answers,2)

Load

*

From tablename;

[#4]

check attached file. I have used cross table.

[jagan]

Hi,

Try like this using Crosstable

CrossTable

(SrNo., Answer)
LOAD *
INLINE [
Qno, 21, 39, 46, 102
1A, Yes, Yes, Yes, Yes
1B, Yes, NO, Yes, Yes
1C, Yes, NO, NO, Yes
1D, Yes, NO, Yes, Yes
];

Regards,

Jagan.

[MayilVahanan]

HI

Try like this

CrossTable

(SrNo., Answer)

LOAD Qno,

     [21],

     [39],

     [46],

     [102]

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1);

[#7]

Hi,

PFA