Find & Replace one cell w/another cell unequal occurrences

  • Thread starter Thread starter RealGomer
  • Start date Start date
R

RealGomer

Sorry if the subject is confusing. I exported a report from Crystal reports
to CSV. After aligning the columns properly, I end up with the one row having
the info I need and the next row having unneeded info. As an example:

AcctNbr1
Balance
AcctNbr2
Balance
Balance
AcctNbr3
AcctNbr4

There are 4,000 rows. How can I copy the info from one cell (AcctNbr) to the
cell(s) with the unneeded info (Balance). Each AcctNbr field is unique and
identifies the data in the remaining cells of that row.

Thank you.
 
So, is there something about the row or the acct # that is unique? Do the
balance rows have no value in columns B - Z?
 
Each AcctNbr row gives the name, address, city, state, zip for the particular
account. The AcctNbr row has info for one year only. Each Balance row has
information for other years.

AcctNbr1 Acme Anvils 1313 Mockingbird Death Valley CA 90818 2007
$500
Balance
2006 $250
Balance
2005 $350

(I tried to line up the year and dollar columns)

Does this help?
 
OK, highlight the workbook and put on a filter Data>Filter>Autofilter

Filter by blanks in column B. In cell A2, overwrite with =A1 and paste down.

Once done, remove filter, highlgiht column and paste special/values
 
Back
Top