How to create column having values repeated for specific number of times












-3















Have to create a column next to existing column. my present table is like this



Existing table



and result needed is like this. Each date value is getting repeated 3 times and getting incremented by 1



Resultant table










share|improve this question

























  • You can write VBA to do this.

    – nicomp
    Jan 1 at 13:00











  • Using SQL there's no way unless you have another column to order your data. And then it's still a very strange task.

    – dnoeth
    Jan 1 at 13:04
















-3















Have to create a column next to existing column. my present table is like this



Existing table



and result needed is like this. Each date value is getting repeated 3 times and getting incremented by 1



Resultant table










share|improve this question

























  • You can write VBA to do this.

    – nicomp
    Jan 1 at 13:00











  • Using SQL there's no way unless you have another column to order your data. And then it's still a very strange task.

    – dnoeth
    Jan 1 at 13:04














-3












-3








-3








Have to create a column next to existing column. my present table is like this



Existing table



and result needed is like this. Each date value is getting repeated 3 times and getting incremented by 1



Resultant table










share|improve this question
















Have to create a column next to existing column. my present table is like this



Existing table



and result needed is like this. Each date value is getting repeated 3 times and getting incremented by 1



Resultant table







sql excel






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 1 at 12:55









Ron Rosenfeld

23.5k41636




23.5k41636










asked Jan 1 at 12:18









SearchSearch

13




13













  • You can write VBA to do this.

    – nicomp
    Jan 1 at 13:00











  • Using SQL there's no way unless you have another column to order your data. And then it's still a very strange task.

    – dnoeth
    Jan 1 at 13:04



















  • You can write VBA to do this.

    – nicomp
    Jan 1 at 13:00











  • Using SQL there's no way unless you have another column to order your data. And then it's still a very strange task.

    – dnoeth
    Jan 1 at 13:04

















You can write VBA to do this.

– nicomp
Jan 1 at 13:00





You can write VBA to do this.

– nicomp
Jan 1 at 13:00













Using SQL there's no way unless you have another column to order your data. And then it's still a very strange task.

– dnoeth
Jan 1 at 13:04





Using SQL there's no way unless you have another column to order your data. And then it's still a very strange task.

– dnoeth
Jan 1 at 13:04












2 Answers
2






active

oldest

votes


















0














Pick any cell and enter:



=DATE(2018,8,21+ROUNDUP(ROWS($1:1)/3,0))


and copy downward.



enter image description here



Here our start cell is one cell to the left of the 21.






share|improve this answer
























  • Thank You this worked

    – Search
    Jan 2 at 10:17



















0














Manually type in the first 3 into A1:A3 (or rows 1 to 3) in A4 (or row 4) reference A1 (row 1) and add 1 to it. Then drag the formula down.



The formula should look like =A1+1






share|improve this answer























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53995365%2fhow-to-create-column-having-values-repeated-for-specific-number-of-times%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Pick any cell and enter:



    =DATE(2018,8,21+ROUNDUP(ROWS($1:1)/3,0))


    and copy downward.



    enter image description here



    Here our start cell is one cell to the left of the 21.






    share|improve this answer
























    • Thank You this worked

      – Search
      Jan 2 at 10:17
















    0














    Pick any cell and enter:



    =DATE(2018,8,21+ROUNDUP(ROWS($1:1)/3,0))


    and copy downward.



    enter image description here



    Here our start cell is one cell to the left of the 21.






    share|improve this answer
























    • Thank You this worked

      – Search
      Jan 2 at 10:17














    0












    0








    0







    Pick any cell and enter:



    =DATE(2018,8,21+ROUNDUP(ROWS($1:1)/3,0))


    and copy downward.



    enter image description here



    Here our start cell is one cell to the left of the 21.






    share|improve this answer













    Pick any cell and enter:



    =DATE(2018,8,21+ROUNDUP(ROWS($1:1)/3,0))


    and copy downward.



    enter image description here



    Here our start cell is one cell to the left of the 21.







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Jan 1 at 13:43









    Gary's StudentGary's Student

    73.5k94063




    73.5k94063













    • Thank You this worked

      – Search
      Jan 2 at 10:17



















    • Thank You this worked

      – Search
      Jan 2 at 10:17

















    Thank You this worked

    – Search
    Jan 2 at 10:17





    Thank You this worked

    – Search
    Jan 2 at 10:17













    0














    Manually type in the first 3 into A1:A3 (or rows 1 to 3) in A4 (or row 4) reference A1 (row 1) and add 1 to it. Then drag the formula down.



    The formula should look like =A1+1






    share|improve this answer




























      0














      Manually type in the first 3 into A1:A3 (or rows 1 to 3) in A4 (or row 4) reference A1 (row 1) and add 1 to it. Then drag the formula down.



      The formula should look like =A1+1






      share|improve this answer


























        0












        0








        0







        Manually type in the first 3 into A1:A3 (or rows 1 to 3) in A4 (or row 4) reference A1 (row 1) and add 1 to it. Then drag the formula down.



        The formula should look like =A1+1






        share|improve this answer













        Manually type in the first 3 into A1:A3 (or rows 1 to 3) in A4 (or row 4) reference A1 (row 1) and add 1 to it. Then drag the formula down.



        The formula should look like =A1+1







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 1 at 13:28









        Dude_ScottDude_Scott

        1577




        1577






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53995365%2fhow-to-create-column-having-values-repeated-for-specific-number-of-times%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Monofisismo

            Angular Downloading a file using contenturl with Basic Authentication

            Olmecas