How to do this

for example i have list of 10 usernames in column and i want to divide them by 5 and put an enter below
1
2
3
4
5
6
7
8
9
10

so the output is like this
1
2
3
4
5

6
7
8
9
10

i can do this manually if the list is small but i have more than 1000 list of usernames, if i do that manually it will take a lot of time

You can do this with Notepad++. Check this out: https://superuser.com/questions/680416/how-to-add-something-every-x-line

Get notepad++
Hit the "macro record" button
press <down arrow> 5x
Press <enter key> to make a line break
stop macro record
play & loop macro until end of file

biglia said:

You can do this with Notepad++. Check this out: https://superuser.com/questions/680416/how-to-add-something-every-x-line

Click to expand...

uncutu said:

Get notepad++
Hit the "macro record" button
press <down arrow> 5x
Press <enter key> to make a line break
stop macro record
play & loop macro until end of file

Click to expand...

Thanks guys for the reply
One more, i have this list :

@dhana_holcek
@andre_tavadjiio
@panjuul6669
@maryambeth
@idham_ibrahim
@icalno16
@fajriramadanmjh
@daengpali
@katarudy
@anandanilam

@junizarbayu_mukti
@awodhalfaridzy
@oot_ongis_
@green.army_elacactuszone
@fadilsyah887
@iiegunadi
@tanasuryana
@ztaufik18
@rahcmadsr
@bagus.s47

@teukumuhammad_rezasaputra
@akmalrizali
@aqran.item
@radhi.krnwn
@garindrayusuf
@putri_923
@akhyyhuda
@mnh_ebou
@b_apras
@enny.permana

I want to change the list from line to row
the output :

@dhana_holcek @andre_tavadjiio @panjuul6669 @maryambeth @idham_ibrahim @icalno16 @fajriramadanmjh @daengpali @katarudy @anandanilam

@junizarbayu_mukti @awodhalfaridzy @oot_ongis_ @green.army_elacactuszone @fadilsyah887 @iiegunadi @tanasuryana @ztaufik18 @rahcmadsr @bagus.s47

@teukumuhammad_rezasaputra @akmalrizali @aqran.item @radhi.krnwn @garindrayusuf @putri_923 @akhyyhuda @mnh_ebou @b_apras @enny.permana

At least dont target indians on instagram

Why dont you try the concatenate function in excel eg =concatenate(a1&" "&a2&" "&a3) etc then copy it down all the way

louisenbarn said:

Thanks guys for the reply
One more, i have this list

Click to expand...

use your brain man. simple <up/down arrow>, <space key> and <enter key> macros can do that too in notepad++ just like you did the first time.
excel formula is easy way too as @manpreet suggested

the easiest way would be to use notepad ++ and replace every 5 with a 5+new line character, and replace every 0 with 0+ new ligne character

I'm always using macro recorder for such tasks