Blank Repeated Values

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate cell with multiple non-blank text values 4
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
Pivot Table - problem with repeated fields 5
Remove Blank values 2
blank values 3
Divide 2 pivot table numbers 3
Make a pivot table from an existing pivot table 2
Copy down (propagate) function/forumula needed 4

Top