I am working with an excel file that has approximately 44300 records for 13 variables. These data represent fecundity estimates for fish caught during sampling. The first variable, "number", indicates the specific number assigned to each specific fish. The second variable, "Egg", indicates the number of eggs measured during analysis. So variable A (Number) will be repeated in column A alongside the count for variable B (Egg). The number off eggs differs for every fish, so the number of times the alphanumeric will be repeated varies for each fish as well. It could go from rows 1 -130, for example. Or rows 28765-28991 etc... For every egg value of 1, I have the corresponding fish number in column A already, but it does not repeat. See the attached images for clarification if I am not explaining this well enough.
The issue I am having is that I do not currently have "number" repeated alongside the egg counts. If I attempt this by hand, copy-pasting each value into their own range of cells, it will take a very long time as there are approximately 44000 rows in this file.
Does anybody here know a way to autofill a single column in excel, but have that autofill function change every time a new number appears. IE Fill "15-C" for rows 1-154, but then change to the next number at row 155 until a new value appears in that column. Repeat until the end of the sheet.
EDIT
Find the file I am working with here: https://dl.dropboxusercontent.com/u/.../combined.xlsx
I am simply trying to complete column A in the pattern you see for the first three fish (15-C, 30-C, 32-B).
EDIT
I solved this issue using the methods found here: http://stackoverflow.com/questions/1...ill-using-that
I realize this may have been a no-brainer to some, but it was giving me trouble. Hope this helps someone in the future.
Bookmarks