I have collected data into a large text file such that each value is space delimited. I would like to import this text file into Excel in order to analyze it better. I have pasted a portion of the text file into Excel in order to attach it to this ticket. Whether I copy and paste the data or import it, I don't care, just as long as I can organize it in Excel.
I need the data to be organized into 5 different columns with the first value going into A1, the second value into B1, and continuing until the fifth value is in E1. Once there, it needs to repeat so that the sixth value is placed in A2, the seventh in B2 until the the tenth value is in E2.
For example, if I had this series of data:
0053 02A3 0000 0000 0000 0054 02A3 0000 0000 0000 0055 02A3 0000 0000 0000
It would need to be organized like this, with each value in it's respective row and column:
0053 02A3 0000 0000 0000
0054 02A3 0000 0000 0000
0055 02A3 0000 0000 0000
I hope that makes sense, let me know if you need any clarification.
Thanks!
Bookmarks