Blank Repeated Values

  • Thread starter Thread starter theb210
  • Start date Start date
T

theb210

I have a list in Column A that displays multiple data in an unfilled
manner. I have a list in Column B that displays multiple data in a
filled manner. How do I autofill the data points in Column A?

Example: A1=1 A2:A9=(blank) A10=2 A11:A19=(blank)
B1:B9=Blue B10:B19=Red

I do not want to manually autofill each data break because there are
30,000+ rows of data (A1:A30000) with data points starting at 1(A1) to
15,000(A29999).

The format looks like a finished pivot table. It looks like I am trying
to copy a finished pivot table and pasting value to another sheet, then
running a pivot table off that. But I am unable to create a pivot table
off the new sheet because the repeated values are blank.

I am running Excel2000 on Windows2000. Is this possible in Excel2000?
 
Back
Top