Skip to Content
Nov 09, 2006 at 05:55 PM

Horizontal to Vertical


Hi all,

I have a custom table with fields like the following

Document No type1 type2 type3 type4 type5

1001 A1 A2 B1 B2 B3

1002 A3 A4 B1 B2 B3

1003 A5 A6 B1 B2 B3

I want to make a select on this table and after the select values should have to come like this.

DocNo type

1001 A1

1001 A2

1001 B1

1001 B2

1001 B3

1002 A3

1002 A4

1002 B1

1002 B2

1002 B3

1003 A5

1003 A6

1003 B1

1003 B2

1003 B3

How it can be done?

Please give me your suggestions