I wan to get the result from below screen shots Using Macro ? Please Help

[sv.thiyagarajan]

Hi Friends,

1. I want the Invoice Nos in C2 with “Comma”(",") Followed By Space(" ") and only 5 Invoice Nos should be in the Row, Next Row should be 5 Invoice Nos and so on.
   510012024, 511012024, 512012024, 513012024, 514012024

2. In Last Row Invoice No should End With Full Stop(".")
   520012024, 521012024, 522012024.

How to get result in the Row(“C2:C4”) by using Macro to Achieve this.

Screen Shots

Please Help How to get results…by Macro. ?

[Lupp]

• Please don’t post screen shots but (reduced, cleaned, …) example files (here a .ods).
• Without additional information what you ask for looks like a bad idea. What do you want to achieve this way?

[Villeroy]

[Python,Calc] Group_Concat for the spreadsheet

[sv.thiyagarajan]

Hi Lupp, For Me Its very Important because, daily i am getting 250 or 300 Invoice… I want automation wih the simple 2 conditions which i mentioned above… thats why i posted here… will hope some one help.

[sv.thiyagarajan]

hi @Villeroy thanks for reply. But , I want BASIC Maro Code and not Python. i Don’t know Python…

[karolus]

C2⇒

=TEXTJOIN(",";1;OFFSET($A$2;(ROW(C1)-1)*5;0;5))

pull down!