Combine rows of data in a worksheet
I am trying to combine data from two companies into one
spreadsheet for the complex. I need to combine the rows
that contain similar data for that time period. For
example, since we are looking at 2 separate companies in
the division, we may have 2 separate entries for customer
# 1009 for fiscal code 04/04. We would like to see just
one entry made for the entire complex. Is there a formula,
or code to do this? I have been trying some things, but
none of them seem to work.
|