Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reorganising Data
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent - Reorganising Data | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
reorganising data | Excel Worksheet Functions | |||
Reorganising Data | Excel Discussion (Misc queries) | |||
Reorganising data - macro needed? | Excel Programming |