Hi!
I have a table with 16 columns and 1000 rows. In this table there is a pattern, say:
4F B1 6C 4E
01 00 00 00 01 4F B1 6C 51 01 00 00 00 04 4F B1
6C 54 01 00 00 00 00 4F B1 6C 57 01 00 00 00 03 etc. etc.
The pattern is: 4F B1 6C 4E, 4F B1 6C 51, 4F B1 6C 54, 4F B1 6C 57
01 , 01 , 01 , 01
00 00 00 01, 00 00 00 04, 00 00 00 00, 00 00 00 03
Instead of being randomly placed, I want to have all the "4F B1 6C 4E" beneath each other in a new column, all the "01" beneath each other a new column and all the "00 00 00 01" beneath each other in a new column. The new table only have three columns!
Unfortunately, I don't know how to do this. Any ideas? Any suggestions will be highly appreciated!
Bookmarks