Need help with VBA code for filtering/arranging data

Hi,

I have an excel file which contains:

columA columB columC columD
ABC45 2502 .... etc
ABC45 2503
ABC45 2504
DSE76 6589
DSE76 5123
FG345 5464
GFDR4 5422
etc...

I need to arrange it this way:

ABC45 2502 2503 2504
DSE76 6589 5123
FG345 5464
GFDR4 5422


Any trick to make this works ?
or can only work it out with VBA ?

Hi, sry for the late reply,

was on vacation.


See the attached file.

So like the exemple stated,
Colum "ID" has to be unique in each row
see sheet2 to what I really want the file to look like
I've highlight in yellow for the specific example.

See if there is anything you can do in VBA to make it works

Thx.