用编程也可以哟
D1=IF(ROW(A1)>6,"",INDEX($A$1:$B$500,ROW(A1),COLUMN(A1)))
右拉,到E1,再下拉
同理
F1=IF(ROW(C1)>6,"",INDEX($A$1:$B$500,MATCH($D1,$A:$A,)+6,COLUMN(A1)))
依次显示A,B列的1-6行
然后 MATCH($D1,$A:$A,)+6,依次根据D列数据+6,就是FG列结果
追问请问大佬,这种比较多且很长的数据,具体应该输入怎样的公式或代码呢
要用编程
无论行数个数是否一致,都可以
Sub aa()
Dim i, k, x
For i = 2 To Range("a65536").End(xlUp).Row
x = WorksheetFunction.CountIf(Range(Cells(1, 1), Cells(i, 1)), Cells(i, 1))
If x = 1 Then
y = WorksheetFunction.CountIf(Range("a:a"), Cells(i, 1))
Z = WorksheetFunction.CountA(Range("l2:cz2"))
Range(Cells(i, 1), Cells(y + i - 1, "j")).Select
Range(Cells(i, 1), Cells(y + i - 1, "j")).Copy Cells(2, Z + 12)
End If
Next
End Sub