Sort

Hi

I have following input

Thq issue has been resolved

Data Investigation

Accepted answers

Please use the below configuration in the Cross Tab,

Group data by these values:

ID [Tick this check box]

Change Column Headers

Subject

Values for New Columns

Marks

Method of Aggregating Values

Sum [Tick this check box]

Many thanks

Shanker V

One way of doing this:

All comments

This can be achieved with the help of Cross-Tab tool.

Please use the below configuration in the Cross Tab,

Group data by these values:

ID [Tick this check box]

Change Column Headers

Subject

Values for New Columns

Marks

Method of Aggregating Values

Sum [Tick this check box]

Many thanks

Shanker V

One way of doing this:

Hi @BRRLL99
You can crosstab the input and sort column by using Select tool. Hope it helps.

Thanks

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703