hi

This is my sample table data in this format:

COL1 COL2 COL3 COL4 COL5 COL6

CatA 10 2 5 15 16

CatB 9 3 4 11 13

CatC 20 22 25 15 16

There are many categories and columns but to simplify it with this table data.

How do I attain the output as this:

COL1 COL2

CatA 10

CatA 2

CatA 5

CatA 15

CatA 16

CatB 9

CatB 3

CatB 4

CatB 11

CatB 13

CatC 20

CatC 22

CatC 25

CatC 15

CatC 16

Sorry for the trouble and thanks a lot