0

Sorry My english So bad. I want to combine data in 2 row.

=TEXTJOIN("",true,G4:G12,"")

Image

enter image description here

Harun24hr
  • 30,391
  • 4
  • 21
  • 36
Dite Morin
  • 11
  • 3

1 Answers1

1

Use TEXTJOIN() like-

=TEXTJOIN("*",TRUE,B2&$C$2:$C$4)

enter image description here

Harun24hr
  • 30,391
  • 4
  • 21
  • 36