Hello all,
I have a data file that is output into a txt. However when importing the file, all data is placed in a single column. I am trying to separate and group the data together by type so that I can graph each type on a calendar to view the time of each instance. I have attached an example text file and picture of the graph I am attempting to make from this data. I have tried using delimiter functions to try to parse out the data but have not had success. The solution has to be able to be applied over a huge list of data points (>1000 rows in single column) otherwise I could manipulate by hand easily. Let me know if you have any suggestions!
Thanks!
Bookmarks