Would anyone have a Macro the help me get the results below?

Workbook name: enlformat2
Worksheet name: enldata
sheet2
sheet3




A B C D Agency LastN FirstN XXX

DoITT Jones Kay
DoITT Smith Bob
Confuse Terry Jerry
Acme Hook Kathy
Acme Fung Jay
OEM Mitchell Robert
DEP Law Frank
DCP Shank Dee
OEM Crane Harry
Confuse Shockey Jay
DoITT Lauben John
DEP Water Logged

The output to appear as follows:


A B C D
Agency LastN FirstN XXX
Acme
Fung Jay
Hook Kathy
Confuse
Shockey Jay
Terry Jerry

DCP
Dee Shank
DEP
Law Frank
Water Logged
DoITT
Jones Kay
Lauben John
Smith Bob



--
53214920