Best way to generate multiples rows

[Hakimipous]

Hello again!

I would liek to ask to community if there is a better way (I guess there is) to deal with a certain situation while cleaning data.

Here is an exemple of my case :

I have a table looking like this :

F1	F2	Employee
Start date	01-01-2016	Marc
Country of Origin	US	Marc
Family situation	Single	Marc

And what I want it to look like in the end is like this

Employee	Start Date	Country of Origin	Family Situation
Marc	01-01-2016	US	Single
Olivier	02-01-2015	Canada	Married
....

The way I use to achieve this is by creating a new field with a formula tool ( looking like : 

IF [F1] = "Start date"
THEN [F2]
ELSE ""
ENDIF 

) 

and repeating this for all the data in F1, and then taking an another step to align the data.

It works! but this really is time consuming, 

So I was wondering if anyone would have a tips to achieve the result I want faster. 

Thanks again !

[danrh · Accepted solution]

The Cross Tab tool is what you're looking for:

Group by the Employee, use F1 as your headers and F2 as your values.

[Hakimipous]

amazing and simple indeed ! 

I tried it before but I see where I was wrong

Thanks!