Dear all,
I need to combine 300 words in a column (separate cells) in to 30 words in single cell each. I will have to do it many more times....
I use the forumula =concatenate(transpose(INDEX(A1:A1000,30*(row()-1)+1):INDEX(A1:A1000,30*(row()-1)+30))&" ") and drag it down.
Problem is I have to F9 remove { } and conotate again for all the rows.
I am looking for VBA/or forumula to short cut this.
Thanks
Krish
I need to combine 300 words in a column (separate cells) in to 30 words in single cell each. I will have to do it many more times....
I use the forumula =concatenate(transpose(INDEX(A1:A1000,30*(row()-1)+1):INDEX(A1:A1000,30*(row()-1)+30))&" ") and drag it down.
Problem is I have to F9 remove { } and conotate again for all the rows.
I am looking for VBA/or forumula to short cut this.
Thanks
Krish