Hi,
I have approximately 6000 rows of information but every 2nd row has information that needs to be combined with the one after:
Columns F to K and L to T are split on two separate rows. I need to combine them into the one row (using the data from Columns A to E - which is the same for each of the two rows).
How do I do this?
Many Thanks!!
Bookmarks