krishnakashyap
New Member
- Joined
- Jul 1, 2015
- Messages
- 3
Hi,
I have a set of data something like below. But its a huge data though.
(Column1 )(Column2 )
Commodity Partnumbers
S71 A06-15789-000
A03-52458-002
S89 A05-15789-000
A08-57778-002
A09-57785-003
S71 A06-15789-000
A03-52458-002
......... thousands of rows
I would like the above data to be sorted in rows like below...
(Column1 ) (Column2 )
S71 S89
A06-15789-000 A05-15789-000
A03-52458-002 A08-57778-002
A09-57785-003.... etc.. Side by side in the same row..
Thanks a lot for your kind attention and any help is greatly appreciated..
I have a set of data something like below. But its a huge data though.
(Column1 )(Column2 )
Commodity Partnumbers
S71 A06-15789-000
A03-52458-002
S89 A05-15789-000
A08-57778-002
A09-57785-003
S71 A06-15789-000
A03-52458-002
......... thousands of rows
I would like the above data to be sorted in rows like below...
(Column1 ) (Column2 )
S71 S89
A06-15789-000 A05-15789-000
A03-52458-002 A08-57778-002
A09-57785-003.... etc.. Side by side in the same row..
Thanks a lot for your kind attention and any help is greatly appreciated..