Before I try to write something that will help with your problem, I want to
make sure I understand what you're trying to accomplish by knowing what you
have currently, and what you want. I couldn't quite figure this out based on
your first post. Perhaps someone else can... Tell me how close I am and
correct me on what I didn't get right.

What you have:
A database that has one product per row with information on the product
stretching out for a number of columns within the same row. Additional
information is not necessairly connected (directly ajacent) to the product
information.

What you want:
A database that lists products in a single row with information on that
product ajacent to that product in the columns to the right.

Close? Not close? I need a better idea of the situation in my head.

"nospaminlich" wrote:

Hi

I have a spreadsheet with information about each product in a single row.

The product number is in Col A and the name is in Col B, then there are sets
of 4 columns with additional information. Most only have 1 or 2 sets of
additional information but a couple have 7 or 8.

I would like to reorganise the data so it is, and can be used, more like a
database.

As there is a lot of data this needs to be automated but I'm afraid it's too
complicated for me and I'm stuck.

What I'm trying to do is:
For each product number in Col A insert a number of rows - this can either
be 7 and remove blank rows later or it can be based on a formula where if
there is data in Col AE it inserts 7 rows, Col AA 6 rows and so on - and
fill down with the info in Cols A & B.

Then cut information from Cols G:J and put that in the second row for that
product, then K:N and put that in the third row and so on, then move down to
the next product.

I should then finish up with a sheet with no data after Col F.

I hope I've described this well enough for someone to help me make this work
otherwise I'm in for a mammoth cut and pastathon doing it manually.

Many thanks in anticipation

Kewa