[Solved] VBA: Data Reorganisation in Excel

  • using excel 97 on windows NT
    looking for a macro or some VBA code to do the following


    i have 2 columns of data (one pair)eg
    T1 L1
    T2 L2
    T3 L3
    T4 L4
    T5 L5
    T6 L6
    ..........etc etc


    and i want to organise it as follows:


    T1 L1 T2 L2 T3 L3 T4 L4
    T5 L5 T6 L6 T7 L7 T8 L8
    T9 L9 .......etc etc


    ie 4 pairs per row
    any help greatly appreciated

  • Hi wildboar,


    Give the attached at try.


    Run the macro called MoveData by pressing Alt-F8 and selecting that macro to run.


    View the code by going in the VBE Alt-F11.


    Hope this helps


    .....Ralph

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!