Need help on formatting a census...

Greetings to all!
I've a large census with hundreds of entries. If this were a small listing, I would manually adjust the information. Since it is so large, and needs to be turned in by morning, I'm seeking your help. We usually receive the data formatted in columns with name, date of birth, gender, etc., listed straight across in a row. In this instance, there are multiple rows for each individual, rather than having all the data laid out horizontally for each person.

This is what it looks like:
Original.JPG

This is how it needs to be:
End Result.JPG

Hoping you can advise a simple and easy fix for this. I am not very tech savvy. Thanking you in advance for your time and kind assistance in this matter!

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

In column A, copied down:

=IFERROR(INDEX('Sheet 1'!$A$2:$A$65,MATCH(0,INDEX(COUNTIF($A$1:$A1,'Sheet 1'!$A$2:$A$65),0),0)),"")

In column B, copied across into column C and down:

=IFERROR(INDEX('Sheet 1'!B$2:B$65,MATCH($A2,'Sheet 1'!$A$2:$A$65,0)),"")

In Column D, copied across and down, an array formula:

=IFERROR(INDEX('Sheet 1'!$E$2:$E$65,MATCH(1,('Sheet 1'!$A$2:$A$65=$A2)*('Sheet 1'!$D$2:$D$65='Sheet 2'!D$1),0)),"")

Array Formulae are a little different from ordinary formulae in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...