Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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