extract and append data to a template

A

amma

Data Sheet
Column A Column B Column C Column D
AE No AE Name Secretary Action
12 Paul Joyce Delete
12 Paul Joyce Retain
15 John Susan Delete
15 John Susan Retain

Template
AE No: column A in data sheet & show 12 AE Name: link column B show Paul
Secretary: link column C show Joyce

Action
I want to extract and append the row under same AE No

The result will be as follow:

From: AE No: 12 AE Name: Paul Secretary: Joyce

Action
delete
retain
 
Top