So, is there something about the row or the acct # that is unique? Do the
balance rows have no value in columns B - Z?

"RealGomer" wrote:

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.
--
Für Elise - Support the Breast Cancer & Heart Foundations