Split File

[pr4t3ek]

QB03654338 AGLQLD2 10/06/2007 0:00 14/02/2008 0:00
QB03654338 AGLQLD2 15/02/2008 0:00 10/04/2008 0:00
QB03654338 AGLQLD2 19/08/2008 0:00 31/12/9999 0:00

to this:

QB03654338 AGLQLD2 10/06/2007 0:00 14/02/2008 0:00 15/02/2008 0:00 10/04/2008 0:00 19/08/2008 0:00 31/12/9999 0:00


So adding it to all to one line if it is the same ID number "QB03654338"

Please see the attached file

[rylo]

Hi

In your exampe file add a new sheet and rename it to OutPut.

Then run the code

Please Login or Register  to view this content.

rylo

[pr4t3ek]

I have to admit, thats truley amazing!
thank you so much!

i'm speechless..