fill in the blanks

  • sample data


    [TABLE="width: 64"]

    [tr]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td]

    3

    [/td]


    [/tr]


    [tr]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td]

    5

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td]

    6

    [/td]


    [/tr]


    [tr]


    [td]

    7

    [/td]


    [/tr]


    [/TABLE]



    desired outcome


    [TABLE="width: 64"]

    [tr]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    3

    [/td]


    [/tr]


    [tr]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td]

    5

    [/td]


    [/tr]


    [tr]


    [td]

    5

    [/td]


    [/tr]


    [tr]


    [td]

    5

    [/td]


    [/tr]


    [tr]


    [td]

    5

    [/td]


    [/tr]


    [tr]


    [td]

    5

    [/td]


    [/tr]


    [tr]


    [td]

    5

    [/td]


    [/tr]


    [tr]


    [td]

    6

    [/td]


    [/tr]


    [tr]


    [td]

    7

    [/td]


    [/tr]


    [/TABLE]

  • Re: fill in the blanks


    Cross posted: http://www.excelforum.com/exce…1-fill-in-the-blanks.html


    Rule #4 - Do not cross-post without supplying a link to the duplicate question on the other forum.


    You also posted this topic on ExcelForum. While you are free to post where ever, every board like this has a similar rule - you must include links to all you posts on other boards.


    Have a read of this to understand the reasons for this rule.


    As there are replies on ExcelForum, this thread has been closed.

Participate now!

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