Fill down Multiple Rows?
My way:
in the cell directly below ABCD corp, type =A2 (or whatever cell the above
value is in).
copy the formula
Highlight the entire column
Edit Go To
Special
Blanks
Paste your formula
Copy the column and paste Special/Values to get rid of the formula.
"Katie" wrote:
This is my question... I have a report generated from access that lists
information in a "tree" like format with the parent information, and then kid
information (it varies how many lines) in the next column over. Is there a
way to copy each parent org below itself so that each row has a parent name
in it?
In the example below, I want something that can help me drag down the org
names into each box below it. Is this possible?
For example;
ABCD Corp John Smith
Jane Doe
1234 Corp George Michael
Bill Rogers
Jim Greene
|