Pivot Table Re-Organizing Data

Dear Forum Users,

I am racking my brain trying to get a Pivot Table to re-organize my wedding invitations. I am uploading into a Wedding Website, and it needs the data in a different format.

The format I have my data in is:

Column Headers

household first name 1 last name 1 EMAIL CITY
household first name 2 last name 2

Example: I have my data in this format.

household | First Name | Last Name |

Jones Family | Tom | Jones |
Jones Family | Linda | Jones |
Jones Family | Johnny | Jones |


The website needs my data in:

Household | First Name 1 | Last Name 1 | First Name 2 | Last Name 2| First Name 3 | Last Name 3.

I need to sort my data into:

Household | First Name 1 | Last Name 1 | First Name 2 | Last Name 2| First Name 3 | Last Name 3.

To Look Like This:

Jones Family | Tom | Jones | Linda | Jones | Johnny | Jones |