Repeated Column Data Transpose From Column to Rows.

  • Hi Guys

    I a need to transpose a variable data set that is that is in 4 columns to 2 rows with a emty column between every column with data.

    I think a macro would be the beter way forward rather than with a IF Statement. Unfortunately I am novice when it comes to coding

    macros and would really appreciate any help.


    Below is a sample of the data in one sheet


    No, Aquifer 1 , Aquifer 2 , Aquifer 3

    1 , Unconfined, Confined ,

    2 , Unconfined, Confined , Uncertain

    3 , Unconfined,

    4 , Unconfined, Unconfined,

    5 , Unconfined, Unconfined, Unconfined


    It must be in the following format on another sheet:


    No 1 , , 1 , , 2 , , 2 , , 2 , , 3 , ,

    Unconfined, ,Confined, ,Unconfined, ,Confined, ,Uncertain, ,Unconfined, ,


    I have also attached a xlsx file


    Thank you in advance for any input.

    Kind regards

    Marius

  • Try:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Hi Mumps

    Thank you very much for the reply and the code.

    Unfortunately, the only output I get is “No” in Cell A1 of the “output” sheet.

    Kind regards

    Marius

  • Try:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • You are very welcome. :)

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

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