Moving cells in a column

0

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

Answer
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login