excel中如何把列中各数据扣出来放到同一个格子内

Question

求高手帮忙

Answer 1

你试一下B4&C4&……一直往后，下面的只要下拉单元格就可以，试试，我也不太懂

Answer 2

FOR EACH CEL IN RANGE(B3:AH3)
IF CEL<>"",THEN S=S & ","
NEXT
RANGE("AJ3")=S
FOR EACH CEL IN RANGE(B4:AH4)
IF CEL<>"",THEN S=S & ","
NEXT
RANGE("AJ4")=S

Answer 3

用&就可以 =B4&J3& 一直和下去 哈哈