RE: Reorganising Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • RE: Reorganising Data
    ... At present I have 1 row for each product code but information for that code ... A database that has one product per row with information on the product ... 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 ...
    (microsoft.public.excel.programming)
  • Re: Automating repetitive tasks-creating text strings from excel into
    ... You should be able to convert the list of numbers into a single row of numbers quite easily using find/replace. ... You would need to remove the final comma at the end of the last number, or just not select it when you copy to the clipboard for pasting into the database search box. ... keystrokes, or can someone help me "loop" the keystrokes in a macro so I can ...
    (microsoft.public.word.docmanagement)
  • Re: New record on a new day (re-post)
    ... In a well-normalized relational database design, ... CommentTypeID (a foreign key, pointing back to the Primary Key in a ... a single row in a table. ... be too difficult to maintain this data in an excel spreadsheet, ...
    (microsoft.public.access.formscoding)
  • [Info-ingres] Ingres/Replicator Stress Test
    ... stress levels, they weren't high enough. ... So on my source database I have a single row table called next_id. ... deadlocking problems. ...
    (comp.databases.ingres)
  • Database vs Data Structure?
    ... I'm trying to decided whether to store the objects in the database ... data-structure in a single row in the database (then unpickle the data ... -able to query objects based on name and id. ...
    (comp.lang.python)