excel row to column conversion
Suppose I am having 3 set of records like

Actno Sufix Amount

000005 230 101000

000005 535 100000

000005 630 -500000

000009 230 222000

000009 535 120000

000009 635 220000

I need to display it as

000005 230 101000 535 100000 630 -500000

000009 230 222000 535 120000 635  220000


excel row to column conversion
===

Suppose I am having 3 set of records like

Actno Sufix Amount

000005 230 101000

000005 535 100000

000005 630 -500000

000009 230 222000

000009 535 120000

000009 635 220000

I need to display it as

000005 230 101000 535 100000 630 -500000

000009 230 222000 535 120000 635  220000

