Hi folks, I am running into an issue with restructuring a database and
feel their must be an easier way than by hand and it seems someone
must have run into this in the past.

I have a spreadsheet that is structured as follows:


Last Name First Name Date of Birth Sending
Location Receiving Location
Equipment
Frankfort John DOB1 School1 Receiving1 Equipment1
Frankfort John DOB1 School1 Receiving1 Equipment2
Frankfort John DOB1 School1 Receiving1 Equipment3
Smith Ron DOB2 School2 Receiving2 EquipmentA
Smith Ron DOB2 School2 Receiving2 EquipmentC


What I need to do is restructure this sheet into a single row for
each
individual based on last name AND first name with Equipment listed in
ascending columns instead of rows. Like:


Last Name First Name Date of Birth Sending
Location Receiving Location
Equipment Equipment Equipment
Frankfort John DOB1 School1 Receiving1
Equipment1 Equipment2
Equipment3
Smith Ron DOB2 School2 Receiving2 EquipmentA
EquipmentB


I have an indeterminant number of Last and first names (my table is
300 individuals and growing) and each individual has an indeterminant
number of equipment pieces (some have 1, some have 20+). My table
currently only has a column range of A to E, so horizontal growth for
as many equipment columns is fine.


Does anybody have a script that will do this? It seems like it should
be simple I am just not VB Savey. Many thanks in advance,


Ryan