用EXCEL VBA将多列数据按首列和首行进行拆分合并?答:k = 1 arr = Range("A1").CurrentRegion.Value ReDim brr(1 To (UBound(arr, 1) - 1) * (UBound(arr, 2) - 1), 1 To 3)For i = 2 To UBound(arr, 2) '列 For j = 2 To UBound(arr, 1) '行 brr(k, 1) = arr(j, 1)brr(k, 2) = arr(1, i)brr(k, 3) =...
excel如何将第一列具有相同数据的行合并到同一行答:D1=LEFT(PHONETIC(INDIRECT("b"&MATCH(C1,A:A,0)&":b"&MATCH(C1,A:A,0)+COUNTIF(A:A,C1)-1)),LEN(PHONETIC(INDIRECT("b"&MATCH(C1,A:A,0)&":b"&MATCH(C1,A:A,0)+COUNTIF(A:A,C1)+1)))+1)如需&,可以在B列加。A列的数据需要排序,即同样的数据连续出现,我看你的数据...