• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Single cell data to multiple rows & columns

    Hi all, I have some data extracted from pdf file.It gives a table data in a single cell. I have attached the sample file for input format I have with me & the expected result as well. Even if I can get the conversion of only cell B4 in proper table matrix; it's fine rest I can manage manually...
  2. L

    Copy paste 6(n) cells from 2 different columns in a third column

    Hi, Thanks a lot!! Please bare with me for the mistakes I do. Yes I agree with r2c2 about the homework. but the lack of knowledge is the cause. Hope I'll now learn fast with very helpful guys like you & Marc and others on this site. r2c2 , I used A:B in column "G" of the example since the number...
  3. L

    Copy paste 6(n) cells from 2 different columns in a third column

    Hi guys, Thanks a lot for the prompt replies. Let me make my question more clear as suggested by Monty. I tried both the solutions. Marc L, the code works fine till the exact multiple of my required number 6 in this case but the remaining numbers are not really considered. I have given in...
  4. L

    Copy paste 6(n) cells from 2 different columns in a third column

    Hi , My input is as follows: Column A Column B 1 51 2 52 3 53 4 54 5 55 6 56 7 57 8 58 9 59 10 60 11 61 12 62 13 63 14 64 15 65 16 66 17 67 18 68 19 69 20 70 And expected ouput is : Column D 1 2 3 4 5 6 51 52 53 54 55 56 7 8 9 10 11 12 57 58 59 60 61 62 13 14 15 16 17 18 63 64 65 66 67 68...
Back
Top