I have 8 colums of information for one item in one row and I need to change
that to about 8 rows of information for the same item. Such as:
A B C
1 stuff junk other needs to become:

A
1 stuff
1 junk
1 other

there is other stuff involved, but this is the heart of the matter.

I have created a new spreadsheet that pulls all the information from the
first spreadsheet, exactly as I want it. I thought I would be able to pull
the information for the one item, then copy and paste as a value to another
spreadsheet, then go back to the first spreadsheet and delete the first row,
moving the second row to forst row position, and then the new spreadsheet
formulas would pull the information from the new first row in the first
spreadsheet.

But Excel, in all its wisdom, deletes in the formula worksheet the reference
to the first row (giving a #ref! error) when the first row in the first data
worksheet is deleted.

Is there a way to stop Excel from being so smart? If the formula
spreadsheet will just pull the data from the first row of the data worksheet,
even if the row is deleted and another row moves up, then I can accomplish my
task.

Any help is much appreaciated!!
Jane