Macro Help

[sanjimmy]

Is it possible to create macro/VB that can generate something like the below example.

Input data:

NAME ID CODE NUM SOURCE
JEEY 3 HYX 11 B
JEEY 33 HYX 55 A
JEEY 43 HYX 1 B
FRAN 88 BTY 5 A
FRAN 78 BTY 88 B


Using Name,Code and the Source as the key - the report should look like this:
Desired result:

NAME ID CODE NUM SOURCE
JEEY 33 HYX 55 A
............................ JEEY 3 HYX 11 B
............................ JEEY 43 HYX 1 B
----- ----- ----- ----- ----- ----- -----
FRAN 88 BTY 5 A ...... FRAN 78 BTY 88 B

The actual result:
A - Left side
B - Right side

Thanks
Jimmy