Disregard this post, my question has been answered in a previous post.

"youngster" wrote:

I've imported 7000 rows of data (accounts) and there are multiple rows for
the same account. I've sorted the data so the multiples are concurrent. Is
it possible to create a macro to collapse the multiple rows so there is only
one visible row for each account? I would still end up with about 2000 rows.