grouping and transform table in load

[bilionut]

Hi everyone,

I need to make a new table in load , grouped by the Item column from this 

LOAD *
Inline (
'Item', 'Suplier', 'Cod'
'AAA', 'S1', '123'
'AAA', 'S24', '234'
'AAA', 'S3', '554'
'BBB', 'S23', 'abc'
'BBB', 'S77', 'yxz'
'BBB', 'S1', 'uus'
'BBB', 'S234', 'ddd'
'CCC', 'S88', 'acadd'
'CCC', 'S55', 'ddee'
);

to this:

[henrikalmen]

Check out GENERIC LOAD.