I've got a lot of data within an xlsx file but the source system didn't out the whole transaction in one single line. It has split the other columns onto the following line, transaction are separated via a blank line.
I've attached the example of what my data looks like in excel for 2 transactions
What i need the data to end up looking like is as per below
I'm hoping that someone can help me out with this..
Please sign in to leave a comment.