excel怎么把一行数变成一列 Excel怎么把一行的数据变成列的呀?
\u7c98\u8d34\u5230Excel\u8868\u683c\u7684\u6570\u5b57\uff0c\u5360\u636e\u4e00\u5217\u600e\u4e48\u53d8\u6210\u4e00\u884c\u554a1\u3001\u6253\u5f00\u9700\u8981\u5904\u7406\u7684Excel\u6587\u6863
2\u3001\u9009\u62e9\u5c06\u8981\u53d8\u6210\u884c\u7684\u8fd9\u4e00\u5217\u6570\u636e
3\u3001\u53f3\u952e\u70b9\u51fb\u5f39\u51fa\u4e0b\u62c9\u7a97\u53e3\u7684\u590d\u5236\u9009\u9879
4\u3001\u5355\u51fb\u4f60\u8981\u53d8\u6210\u884c\u7684\u7b2c\u4e00\u4e2a\u5355\u5143\u683c
5\u3001\u5728\u5f85\u7c98\u8d34\u9009\u9879\u7684\u884c\u4e2d\uff0c\u70b9\u51fb\u9f20\u6807\u53f3\u952e-\u7c98\u8d34\u9009\u9879-\u8f6c\u7f6e\u3002\u4e5f\u53ef\u4ee5\u9f20\u6807\u53f3\u952e-\u9009\u62e9\u6027\u7c98\u8d34-\u8f6c\u7f6e
6\u3001\u70b9\u51fb\u8f6c\u7f6e\u6309\u952e\uff0c\u6210\u529f\u53d8\u6210\u4e00\u884c\u6570\u636e
\u76f4\u63a5\u590d\u5236\u8981\u8f6c\u5316\u7684\u884c\u6216\u5217\uff0c\u7136\u540e\u9009\u4e2d\u4f60\u8981\u8f6c\u6362\u5230\u7684\u90a3\u4e2a\u5355\u5143\u683c\uff0c\u76f4\u63a5\u9009\u62e9\u6027\u7c98\u8d34\uff0c\u91cc\u9762\u6709\u4e2a\u8f6c\u7f6e\u7684\u9009\u9879\u5728\u4e0b\u9762\uff0c\u7136\u540e\u786e\u5b9a\u5c31\u662f\u4e86
选中一行,复制,右击空白表第一个单元格,“选择性粘贴”,选“转置”,确定。
绛旓細灏戞灄瀵鸿惃鐡﹁开鍗 閲囩撼鏁:4640 鑾疯禐鏁:50086 鍚慣A鎻愰棶 绉佷俊TA 鍏虫敞 灞曞紑鍏ㄩ儴 Excel鎶婁竴鍒鐨勬暟鎹鍙樻垚鍙︿竴鍒楃殑鏂规硶: 宸ュ叿鍘熸枡 Windows10 Excel2021 鑱旀兂y7000 1銆侀鍏堟墦寮Excel閫変腑鍘熷垪濡備笅鍥炬墍绀: 2銆佺劧鍚庨紶鏍囧彸鍑,鍐嶇偣鍑汇愬鍒跺浘鏍囥戝涓嬪浘鎵绀: 3銆佸啀榧犳爣鍙冲嚮,閫夋嫨銆愮矘璐村浘鏍囥戝涓嬪浘鎵绀: 4銆佹渶鍚庣湅鏁堟灉...
绛旓細濡傚浘 濡傚浘锛宖1=IF(ROUNDUP(ROW()/3,0)>COUNT(A:A),"",IF(MOD(ROW(),3)=1,ROUNDUP(ROW()/3,0),""))g1=IF(ROW()>COUNTA(B:D),"",INDEX(B:D,ROUNDUP(ROW()/3,0),MOD(ROW()-1,3)+1))閫変腑f1鍜実1涓嬫媺
绛旓細閫夐」銆3. 鍦"浠庡乏"閫夐」涓紝閫夋嫨瑕佹斁缃鍚嶇殑鏂板垪銆4. 鍦"鍒嗛殧绗"涓嬫媺鑿滃崟涓夋嫨閫楀彿浣滀负鍒嗛殧绗︺5. 纭璁剧疆鍚庯紝Excel灏嗚嚜鍔ㄥ皢濮撳悕绉诲姩鍒版柊鐨勫垪涓紝骞跺湪姣忎釜濮撳悕鍚庨潰娣诲姞涓涓楀彿鍒嗛殧鐨鏁板瓧锛岃〃绀哄搴旂殑骞撮緞銆傞氳繃浠ヤ笂姝ラ锛屾偍灏卞彲浠ヨ交鏉惧湴灏嗕竴琛鏂囧瓧鍙鍒涓鍒鍗曞厓鏍间腑銆傚笇鏈涜繖鍙互甯姪鎮紒
绛旓細鎴戜滑灏嗛紶鏍囧乏閿偣鍑讳竴涓嬬澶存墍鎸嘊2鍗曞厓鏍硷紝鍦板潃灏辫淇敼浜 鐐瑰嚮绠ご鎵鎸囷紝灏卞睍寮浜嗗璇濇 鐐瑰嚮瀹屾垚锛屾垜浠氨鑳界湅鍒扮粨鏋 2銆佸嚱鏁板叕寮忚绠楁硶 鍏堟壘鍑衡*鈥濇墍澶勭殑浣嶇疆 B2鍗曞厓鏍煎叕寮忥細=FIND("*",A2)B2鍗曞厓鏍煎叕寮忥細=LEFT(A2,FIND("*",A2)-1)姝ゆ椂寰楀埌鐨1250鏄枃鏈紝涓嶆槸鏁板瓧锛屽鏋滆繖涓暟瀛楀弬涓庤绠楋紝...
绛旓細濡傛灉a1涓轰腑鏂囥乤2涓鸿嫳鏂囷紙鎴栬呯浉鍙嶏級锛屽湪b1涓緭鍏 =IF(MOD(ROW(),2)=1,OFFSET(A1,MOD(ROW(),2),0),OFFSET(A1,MOD(ROW(),2)-1,0))锛岀劧鍚庝笅鎷夈
绛旓細1銆佹墦寮闇瑕佸鐞嗙殑琛ㄦ牸,濡備笅鍥,闇瑕佸皢杩涓琛鐨勬暟鎹鍙樻垚涓鍒銆 2銆侀変腑鏁版嵁鎵鍦ㄧ殑琛,鐐瑰嚮榧犳爣鍙抽敭,閫夋嫨銆庡鍒躲忋 3銆佺偣鍑婚渶瑕佺矘璐存暟鎹殑鍒,鐐瑰嚮榧犳爣鍙抽敭,閫夋嫨銆庨夋嫨鎬х矘璐淬,鍐嶉夋嫨銆庣矘璐村唴瀹硅浆缃忋 4銆佽繖鏍锋搷浣滀笅鏉,鍘熸潵妯帓鎵鍖呭惈鐨勬暟鎹,灏卞彉鎴愮珫鎺掓暟鎹簡銆 浠ヤ笂灏辨槸excel鎶妯帓鍙樼珫鎺掔殑鏁欑▼浜,瀛︿細浜嗙殑灏...
绛旓細1銆佸惎鍔ㄥ姙鍏蒋浠跺伐鍏凤紝鏂板缓绌虹櫧excel琛ㄦ牸銆2銆佸湪绌虹櫧鍖哄煙濉厖鑷繁闇瑕佹祴璇曠殑鍐呭銆3銆佸洜涓鸿鎶婂琛屾暟鎹悎骞跺埌涓琛涓紝閫夋嫨瑕佸悎骞剁殑琛岋紝鎷夊鍒楃殑瀹藉害銆4銆佺劧鍚庨夋嫨闇瑕佸悎骞跺埌涓琛屾暟鎹殑杩涓鍒鏁版嵁銆5銆佺劧鍚庤繘鍏ュ湪寮濮嬭彍鍗曚腑锛岄夋嫨缂栬緫鍐嶉夋嫨濉厖锛屽湪濉厖閫夋嫨涓夋嫨鍐呭閲嶆媿鍗冲彲銆6銆佽繖灏辨槸鏈鍚庣殑鏁堟灉浜嗐
绛旓細excel1琛鍗佸洓鍒楀彉鎴愪竴琛5鍒楀姙娉曞涓嬨1銆佹墦寮闇瑕佸皢澶氳鏁版嵁杞崲涓涓鍒鏁版嵁鐨EXCEL琛ㄦ牸锛屽湪杩欓噷鍙互鐪嬪埌鍘熸湰鐨勬暟鎹2銆佸湪绗涓琛鏁版嵁涓嬪垪鐨勬渶涓嬫柟绗竴涓崟鍏冩牸鍐呰緭鍏ャ3銆侀紶鏍囩偣鍑昏鍗曞厓鏍间笅鏂逛細鍑虹幇涓涓粦鑹插皬鏂瑰潡鎸夐挳锛岀偣鍑绘嫋鍔ㄨ鎸夐挳鍚戝悗鎷栧姩鏁版嵁杩涜鍒犲噺锛屽垹鍑忎负涓琛5鍒楀嵆鍙
绛旓細鍋囪鍘熸暟鎹湪A鍜孊鍒楋紝濡傚浘锛欶2鍏紡锛=TRIM(MID(SUBSTITUTE(SUBSTITUTE(PHONETIC(B$2:B$100),",",""),"c",REPT(" ",LEN(SUBSTITUTE(PHONETIC(B$2:B$100),",","")))&"c"),LEN(SUBSTITUTE(PHONETIC(B$2:B$100),",",""))*ROW(A1)+1,LEN(SUBSTITUTE(PHONETIC(B$2:B$100),","...
绛旓細5. 閫夋嫨"鎻掑叆鍓创鏉夸腑鐨勮"閫夐」銆傝繖灏嗘妸鍓创鏉夸腑鐨勮鎻掑叆鍒板綋鍓嶅厜鏍囨墍鍦ㄧ殑浣嶇疆銆6. 妫鏌ヨ皟鏁村悗鐨勮〃鏍硷紝纭繚琛屽凡缁忔垚鍔熺Щ鍔ㄥ埌姝g‘鐨勪綅缃7. 淇濆瓨鏂囦欢浠ヤ繚鐣欐洿鏀广傝浣忥紝鍦ㄨ繘琛屼换浣曚慨鏀逛箣鍓嶏紝鏈濂藉厛澶囦唤鍘熷鏂囦欢锛屼互闃插嚭鐜版剰澶栨儏鍐点傝鎶奅xcel琛ㄦ牸涓殑鍏朵腑涓琛寰涓婅皟锛屽彲浠ユ寜鐓т互涓嬫楠よ繘琛屾搷浣滐細1. ...