怎樣將大量不同資料由直式轉橫式?
例如: (以下是要轉的資料-直式)
16271 - 0 - 7028
ThaniM. Snow
Forest
L
Men Function
16271 - 0 - 7028
ThaniM. Snow
Forest
XL
Men Function
16271 - 0 - 7030
ThaniM. Snow
Rust
S
Men Function
16271 - 0 - 7030
ThaniM. Snow
Rust
M
Men Function
16271 - 0 - 7030
ThaniM. Snow
Rust
L
Men Function
16271 - 0 - 7030
ThaniM. Snow
Rust
XL
Men Function
16271 - 0 - 7031
ThaniM. Snow
Mouse
S
Men Function
16271 - 0 - 7031
ThaniM. Snow
Mouse
M
Men Function
16271 - 0 - 7031
ThaniM. Snow
Mouse
L
(以下已轉為橫式的資料)
16271 - 0 - 7031ThaniM. SnowMouseXLMen Function
16271 - 0 - 7031ThaniM. SnowMouseXXLMen Function
16273 - 0 - 7030AnimalM. SnowRustSMen Function
16273 - 0 - 7030AnimalM. SnowRustMMen Function
16273 - 0 - 7030AnimalM. SnowRustLMen Function
16273 - 0 - 7030AnimalM. SnowRustXLMen Function
16273 - 0 - 7030AnimalM. SnowRustXXLMen Function
16273 - 0 - 7031AnimalM. SnowMouseSMen Function
16273 - 0 - 7031AnimalM. SnowMouseMMen Function
16273 - 0 - 7031AnimalM. SnowMouseLMen Function
16273 - 0 - 7031AnimalM. SnowMouseXLMen Function
16273 - 0 - 7031AnimalM. SnowMouseXXLMen Function
16312 - 0 - 7026Oso BlancoM.CobaltSAccessories
請不要答選擇性貼上。謝謝!!!
怎樣將EXCEL大量不同資料由直式轉橫式?
2013-05-04 9:08 pm
回答 (2)
2013-05-05 1:46 am
✔ 最佳答案
設資料從 A1 開始C1=A1&" "&A2&" "&A3&" "&A4&" "&A5
C2=INDIRECT("A"&5*ROW($A1)+1)&" "&INDIRECT("A"&5*ROW($A1)+2)&" "&INDIRECT("A"&5*ROW($A1)+3)&" "&INDIRECT("A"&5*ROW($A1)+4)&" "&INDIRECT("A"&5*ROW($A1)+5)
然後把公式從 C2 往下拉
please try
2013-05-05 6:06 pm
設資料從 A1 開始
C1=A1&" "&A2&" "&A3&" "&A4&" "&A5
C2=INDIRECT("A"&5*ROW($A1)+1)&" "&INDIRECT("A"&5*ROW($A1)+2)&" "&INDIRECT("A"&5*ROW($A1)+3)&" "&INDIRECT("A"&5*ROW($A1)+4)&" "&INDIRECT("A"&5*ROW($A1)+5)
然後把公式從 C2 往下拉
please try
C1=A1&" "&A2&" "&A3&" "&A4&" "&A5
C2=INDIRECT("A"&5*ROW($A1)+1)&" "&INDIRECT("A"&5*ROW($A1)+2)&" "&INDIRECT("A"&5*ROW($A1)+3)&" "&INDIRECT("A"&5*ROW($A1)+4)&" "&INDIRECT("A"&5*ROW($A1)+5)
然後把公式從 C2 往下拉
please try
收錄日期: 2021-04-16 16:15:39
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20130504000051KK00109