I am trying to pull data from a single large column into multiple columns that allow for easier comparison. I have attached the top few lines as an example to the layout. The spacing is not consistent, so a simple function wasn't working for me. I am thinking that there is a way to find a cell, such as "locus_tag" and copy/paste the contents immediately to the right. Thanks for the help.
Bookmarks