Regarding multiplying your string name

Parth Dhir

February 07, 2019 22:10
Edited

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.

0

Comments

3 comments

Konsta Danyliuk

February 08, 2019 08:38

Edited
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

Comment actions Permalink
Parth Dhir

February 08, 2019 14:45
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

Comment actions Permalink
Konsta Danyliuk

February 08, 2019 15:12
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

Comment actions Permalink

Please sign in to leave a comment.