Good day I have a excel sheet that have data in Column A-N. The data in rows represents various transactions. To split the transactions the new transaction starts with "Source" in Column A.
Now as each transaction has it's own makeup, there is no definite number of lines between each transaction, to explain the first 5 times that the word "Source" Appears in column A is at Line 2, 17, 24, 37, 43. Also this sequence will change each day.
I am looking for a way to split each transaction, so that I could filter the results easier.
As there is a lot of personal info I cannot post the original spreadsheet.
Now as each transaction has it's own makeup, there is no definite number of lines between each transaction, to explain the first 5 times that the word "Source" Appears in column A is at Line 2, 17, 24, 37, 43. Also this sequence will change each day.
I am looking for a way to split each transaction, so that I could filter the results easier.
As there is a lot of personal info I cannot post the original spreadsheet.