Help with VBA filtering data (i think only vba can help)

[[email protected]]

Hi,

I need to arrange data in a way so that I can do my mail merge after.
for example:

ColumA ColumB
ABC 123
DEF 254
ABC 456
GFD 569
ABC 789
DEF 898
etc...

I want them to arrange to:

ColumA ColumB ColumC ColumD columE
ABC 123 456 789
DEF 254 898
GFD 567


etc... any help ?

thx.

[JOHN H. DAVIS]

Is it OK to sort the data first?

[[email protected]]

Is it OK to sort the data first?

Hi,

yeah you can sort data first.
so that we can start with
ABC
ABC
ABC
DEF
DEF
etc....

I've attach a small sample. see tab "result" for what im looking for.

Thx.

[JOHN H. DAVIS]

You'd have to sort first on Column A

Please Login or Register  to view this content.