Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Promoted
很難-excel 公式如何鎖定兩列
sheet 1 有abc 三欄,分別有不同資料
sheet 2--我要combine a1&b1 在a1
combine a1&c 1在a2
combine a2&b2 在a3
conbine a2&c2 在a4
如此類推....
請問有公式可以完成嗎?不用一各一個設定
我想了好久都無法完成
3 Answers
Rating
- 7 years agoFavorite Answer
- HarmonicaLv 77 years ago
=OFFSET(sheet1!$A$1,INT((ROW()-1)/2),0)&OFFSET(sheet1!$A$1,INT((ROW()-1)/2),MOD(ROW()-1,2)+1)
Still have questions? Get your answers by asking now.