I have 2 columns with so many rows (eg: A1=1, A2=2, ... An=n and B1=a, B2=b, ... ,Bn=xx),
how to combine two columns to one column in this format (eg: C1=1, C2=a, C3=2, C4=b, ... C(n+1)=n, Cn=xx)?
Excel 的問題
2008-12-18 10:40 pm
回答 (1)
2008-12-19 6:01 am
✔ 最佳答案
三種公式, 任君選擇:C1=OFFSET(A$1,INT(ROW(A2)/2)-1,MOD(ROW(A2),2))
C1=INDEX(A:B,INT(ROW(A2)/2),MOD(ROW(A2),2)+1)
C1=INDIRECT(ADDRESS(INT(ROW(A2)/2),MOD(ROW(A2),2)+1))
輸入以上任何一條公式後, 將C1下拉
收錄日期: 2021-04-13 16:18:41
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20081218000051KK00683