Repeating data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Problem with the following imported data. I have account numbers in column A. Columns B, C, D contain data with multiple lines of data. (one to many relationship). Is there a function that will allow me to repeat the data in column A until the next cell contains different data.. and continue on as such? Example below. Thanks much

account# adjustment Qt
1234567 80065
80072
80321
2121212 80072
90032

etc.......
 
1. Select your range in column A.
2. Press F5 > Special > Blanks.
3. Press <ctrl><->.
4. Select "Entire row".

HTH
Jason
Atlanta, GA
-----Original Message-----
Problem with the following imported data. I have account
Click to expand...
numbers in column A. Columns B, C, D contain data with
multiple lines of data. (one to many relationship). Is
there a function that will allow me to repeat the data in
column A until the next cell contains different data.. and
continue on as such? Example below. Thanks much!
 
Oops - that's for deleting blank rows. Sorry. Use this:

1. Select your range in column A.
2. Press F5 > Special > Blanks.
3. Press "=" and click the first cell in col. A that
contains the first value.
4. Press <ctrl><enter>.

Jason
 
Back
Top