Hi, I need help extracting information from a csv with the data looping in every 9th row. See below image. I need to extract information in column B. Example:
Bank reference 1: 1234
Bank reference 2: 1233
Bank reference 3: 1223
And have to do the same for other rows as well.
I need to get the result like this:
How can I do it?