I'm having trouble with my matlab table, the situation is as follows:
My table have nine columns.
I need to create a total of three new tables (M2,M3 and M4), and then group the data into one of the new tables depending on the ”RecordTime”-column.
If there are two identical ”Recordtimes” after one another, I need to create a new table (M2) and add the rows, if there are two identical again, I need to copy and add them to the same table (M2).
For example: Part of my table looks like this:
As you can see, I have two identical times, so the first two rows should be added to my M2 Table. The following two times are also identical, so they should also be copied to the same M2 table.
Some rows will have three identical times, they should then be copied to a new Table called M3, there can even be four identical times, which I need to put in my M4 table.
The dates are already sorted in ascending order, and there will only be two, three or four identical times, never five or six. Every time has at least one pair.
Any help or input here would be appreciated!
Thanks in advance!
Best Answer