Creating Identical rows for different people

[Deano478]

Hi guys,

I have an input dataset like so:

Name	Partner	Director	Manager	G2	G1	Team Name	Status
ABC Limited	Dean Test	Leon Test	Sean Test	Dylan Test	Gary Test	Accounts	Active

What I need to do is generate an identical row for each person so the output would look something like this:

Name	Partner	Director	Manager	G2	G1	Team Name	Status
ABC Limited	Dean Test					Accounts	Active
ABC Limited		Leon Test				Accounts	Active
ABC Limited			Sean Test			Accounts	Active
ABC Limited				Dylan Test		Accounts	Active
ABC Limited					Gary Test	Accounts	Active

Is this possible cheers for any help in advance I'm really stuck here.

[Christina_H · Accepted solution]

Something like this would work