I have problem in getting the final table which look like the following:

col A B C D E ...
row1 120 PC Keyboard
row2 310 Monitor
row3 450 Mouse Scanner Server CDROM

Our customers normally will give us very long list which look something like
this:
120 PC
310 monitor
120 Keyboard
450 Mouse
450 Scanner
450 Server
450 CDROM

We can do it by using the filter function and copy the item one by one, but
sometimes we did left out some of it. Do anyone have any idea in doing that?