Hello Everyone,
I am uploading a CSV from a PLC, doing so the rows are in groups of 10 cells (columns B-K), below that in the next row is also 10 and for 4500 cells (450 rows down), my PLC data is 6 cells worth of data (B-G) I need to shift H-K down one row and to the front B-G, I can do this by cutting and inserting cells but this is going to take FOREVER.... can someone point me in the write direction for an easier way of doing this.
Below is what I have done with cut and insert manually, the 'good data' is after I change it and below is how it looks after its imported from the CSV/PLC
