Dear Sirs,

This a variation of Question that has been raised before for similar question that has been solved by the help of Variatus by using a formula instead of a macro in the following link

https://www.teachexcel.com/talk/3699/move-data-on-alternate-row-to-column-by-using-macro

**In the new scenario, I want the hyperlink function in the original column is still working.**

**I also attached a sample of a worksheet (File Move data from alternate rows to the next column).**

I need to keep the data in the first row and the alternate row in the same sheet and next to each other.

The simulation data will be as follows

Original Data Modified Data

Column A Column A Column B

A1 A1 A2

A2

A3 A3 A4

A4

A5 A5 A6

A6

A7 A7 A8

A8

A9 A9 A10

A10

A11 A11 A12

A12

After moving the data in alternate row to the next column, I need to delete the original alternate row.(Delete row A2,A4,A6,A8,A10 etc), and the final data will be as follows :

Modified Data

Column A Column B

A1 A2

A3 A4

A5 A6

A7 A8

A9 A10

A11 A12

etc

**I need the hyperlink function in the original column (Column A, ie A1, A3,A5,A7,A9 etc) is still working.**

Looking forward to having your further help in this regards

Many thanks and best regards

Arsil Hadjar