Rearranging Data, Sheet 1 into Sheet 2

  • Thanks for the info ...


    30 Columns and 5'000 rows will require using Arrays


    As soon as I have a moment ... will dive into your code ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • That works soo much better and much faster. I am having trouble changing the number of columns "Languages". I have changed the lstep to 29 and it is till giving me 6 results per code

  • Glad to hear it is an improvement ...


    Quite honestly ... have not had the time to test it ...


    As soon as I have a moment ... will check the step calculation ...;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Quickly checked at my end ... everything seems fine ...


    Would you mind posting a sample file with the number of languages you want ... and say 5 to 10 records ...;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    Not exactly the same format ...;)


    In your initial file, Column B or English had to be skipped ... 7 Columns and 6 Languages to display ...


    Up until now ...the Number of Languages was designed to be a manual adjustment ...


    Will prepare the two modifications .... as soon as you do confirm Column B has to be re-integrated in the process ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    To be on the safe side, in terms of performance, for 30 Columns and 5'000 rows, below is your optimized Array Transformation

    to handle all your languages and translations ....



    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

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