I have several rows that each row has data related to an individual location with details about it and 5 items that will be unique for each of the locations.
What I'm needing is a formula or a macro that will take the location and its details and then the 1st items and put them in a single row then repeat one row down the same location information but skip item 1 and return item 2. Repeating this process until there are no more items for location A and then move to location B and item 1.
This is for a document that I will send out to have it filled in by others & I will receive back some with over 100 rows of locations and others that have less than 10, I'll need to make sure the formula works regardless of the number of rows.
What I'm needing is a formula or a macro that will take the location and its details and then the 1st items and put them in a single row then repeat one row down the same location information but skip item 1 and return item 2. Repeating this process until there are no more items for location A and then move to location B and item 1.
This is for a document that I will send out to have it filled in by others & I will receive back some with over 100 rows of locations and others that have less than 10, I'll need to make sure the formula works regardless of the number of rows.