Regarding multiplying your string name

2 followers
0
Avatar

I am working on 1 column with different names on it. for example:-

1. Parth

2. Parth

3.Parth

4. Paul

5. Paul

6. Mark

7.Mark

 

I want each name to 24 times in a column. like

NAME       ROWNUMBER

1. Parth        1

2. Parth        2

.                   3

.

.

24. Parth     24

25. Paul       1

2.Paul          2

.

.

24. Paul      24

 

What I did is, groupby (columnname) and in next column grouprownumber. I am stuck what to do now.

Parth Dhir

3 comments

  • Avatar
    Konsta Danyliuk

    Hello Parth.
    I guess the easiest way to achieve this is to use EXPLODE_RANGE function.

    • For example - you have 3 names at the Name column.
      John
      Lisa
      Tom
    • You would like to repeat every name let's say 3 times, like:
      John
      John
      John
      Lisa
      Lisa
      Lisa
      Tom
      Tom
      Tom
    • At the next column introduce the formula EXPLODE_RANGE(1;3) - this will return the next result:

    • If you need to repeat the name 24 time, the right formula is EXPLODE_RANGE(1;24)

    Hope this approach helps.

    0
  • Avatar
    Parth Dhir

    If you have 3 name. you can only EXPLODE_RAGE 3 times. 

    Same like I have 20 names, if I do EXPLODE_RANGE(1;24)

    It is still giving me 20 times 1 name.

    0
  • Avatar
    Konsta Danyliuk

    Hello Parth.

    The function EXPLODE_RANGE will repeat every record at the sheet given number of time. So if you have 20 names (20 records I assume) and introduce the formula EXPLODE_RANGE(1;24), it will make 480 records (20 Names * 24 times).

    By default, EXPLODE_RANGE will return only 20 records at the preview mode. You would need to rerun the Workbook to view full results.

    0
Please sign in to leave a comment.