Hi Guys,
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
Attached files
example.xlsx
What i need the data to end up looking like is as per below
results.xlsx
I'm hoping that someone can help me out with this..