Hi,
I'm looking for a code to do the following:
Move all J1. cells shown in data1 (below) to resemble data2:
data1:
ColA ColB ColC ColD ColE ColF ColG ColH
VDD_AB5 ; J.F0613 J1.6151 J1.5181 J1.6471 J1.5501 J1.5831
VDD_AC4 ; J.H0613 J1.231 J1.241 J1.251 J1.531
data2:
VDD_AB5 ; J.F0613
; J1.6151
; J1.5181
; J1.6471
; J1.5501
; J1.5831
VDD_AC4 ; J.H0613
; J1.231
; J1.241
; J1.251
; J1.531
Note:
There are about 1000 rows so the process will need to continue until all rows containing the VDD prefix are accounted for.
"VDD_..n"
VDD_ = are all in ColA
..n = corresponds to the number of J1. in a row.
Sample spreadsheet attached.
Thank you in advance,
Eddie