Find & Replace one cell w/another cell unequal occurrences
 

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

Find & Replace one cell w/another cell unequal occurrences
 

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

Find & Replace one cell w/another cell unequal occurrences
 

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


"Sean Timmons" wrote:

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

Find & Replace one cell w/another cell unequal occurrences
 

OK, highlight the workbook and put on a filter DataFilterAutofilter

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

"RealGomer" wrote:

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


"Sean Timmons" wrote:

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