Selectively apply text to columns

I’ve got csv files that are delimited by tabs. Generally, the data is all in the first column but sometimes there’s information in the second and third columns. How can I selectively apply ‘Text to columns’ in excel so that data isn’t overwritten?For example, in the image attached, data sample rows 39, 42, 46-49 etc will be overwritten. I can do a workaround of filtering etc but there must be a quick way of doing this…