Excel macro help

[sanjimmy]

Is it possible to create macro 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
blanks blank blank JEEY 3 HYX 11 B
blanks blank blank JEEY 43 HYX 1 B
----- ----- ----- ----- ----- ----- -----
FRAN 88 BTY 5 A FRAN 78 BTY 88 B


Thanks
Jimmy

[duane]

maybe if you provide the critiera or logic behind the redone layout