Hi Excel gurus,
I have a task I'm stuck on and need help please.
I have multiple rows with the same data up to a point i.e. columns A:J then the data changes from K:Q. if K:M has data then N:P will be empty and visa versa. So I'm looking for a way to compress the data into one row.
The ID will be the identifier and there are possibly thousands of rows of data each time.
If there are more than 2 records for credit no's then only one credit number record needs to be shown, doesn't matter which on so could be the earlier or latest. This is the same with the receipts. I have shown this in the attachment.
Hope the image is more clearer than my explanation.
Thanks
Bookmarks