The sample you attached does not look like the image you posted ( nothing in RED?)? There is data in two columns, also. Is it the A or D column? Power Query should solve this I think, once we know what you need exactly

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post