I have a CSV file where some data has headers. The cycle on the line repeats, but as you see it does not have any header info. How do I get the columns to the right to look like the example below. Sorry if I am not explaining properly, but hopefully the graphic helps.
original
Want to convert to:
original
Timestamp | Block | Step | Mnemonic | Value | Tol_Low | Tol_High | |||||||||||||||
23:03.5 | 50 | 1 | MGBLHL14 | 23434 | 322134 | 2342 | 23:03.5 | 50 | 1 | CM37208B | 123412 | 213412 | 1234 | 23:03.5 | 50 | 1 | CM30804B | 23421 | 123413 | 2134124 | 23:03.5 |
Want to convert to:
Timestamp | Block | Step | Mnemonic | Value | Tol_Low | Tol_High |
23:03.5 | 50 | 1 | MGBLHL14 | 23434 | 322134 | 2342 |
23:03.5 | 50 | 1 | CM37208B | 123412 | 213412 | 1234 |
23:03.5 | 50 | 1 | CM30804B | 23421 | 123413 | 2134124 |