can i convert the following data into a crosstable?

[fallenangel6]

Hi,

i have data similar to the attached data. is there anyway by which i could reduce columns 3 to 8 into one single column

[kaushiknsolanki · Accepted solution]

Hi,

You should try Crosstable() function.

So the load script will look like below.

Crosstable(Type,Value,5)

Load Id,

Region,

RH,

Entity,

Dept,

[Pan Valid],

[Pan Invalid],

[Pan N/A],

[Mobile Valid],

[Mobile Invalid],

[Mobile N/A]

From xyz;

Regards,

Kaushik Solanki