Thaum ua haujlwm nrog cov qauv ntawv, qee zaus koj yuav tsum los hloov lawv, uas yog, ntawm cov lus yooj yim, tig rau lawv. Tau kawg, koj tuaj yeem cuam tshuam cov ntaub ntawv manually, tab sis Excel muaj ntau txoj kev los ua kom yooj yim thiab sai dua. Cia peb tawg lawv hauv kev nthuav dav.
Transposition txheej txheem
Transposing a matrix yog cov txheej txheem hloov kab thiab kab hauv cov chaw. Hauv Excel, muaj ob txoj kev rau kev hloov: siv qhov ua haujlwm THAUJ thiab siv qhov cuab yeej cuab tam. Xav txog txhua yam ntawm cov kev xaiv no rau ntau yam.
Txoj kev cai 1: KEV THAWJ QHIB
Muaj nuj nqi THAUJ belongs rau qeb ntawm cov tswv "Cov kev txuas thiab cov arrays". Lub peculiarity yog tias, zoo nkaus li lwm yam haujlwm uas ua hauj lwm nrog arrays, ntawm cov zis tsis yog tus txheem ntawm lub cell, tab sis ib tug tseem array ntawm cov ntaub ntawv. Muaj nuj nqi syntax yog yooj yim heev thiab zoo li qhov no:
= THAUJ (array)
Ntawd yog, qhov sib cav ntawm tus neeg teb xov tooj tsuas yog siv rau cov array, hauv peb qhov kev hloov hauv qhov kev hloov kho.
Cia peb saib seb qhov kev ua no siv tau piv txwv li cas nrog tus qauv tiag tiag.
- Xaiv lub npliag cell ntawm daim ntawv, peb npaj yuav ua rau cov kev hloov hauv kev hloov ntawm sab saum toj ntawm tes. Tom ntej, nyem rau ntawm lub cim "Ntxig rau kev ua haujlwm"uas yog nyob ze ntawm lub mis bar.
- Tua tawm Muaj nuj nqi masters. Qhib ib qeb hauv nws "Cov kev txuas thiab cov arrays" los yog "Daim ntawv teev npe tag nrho". Tom qab nrhiav lub npe "THAUM"ua rau nws xaiv thiab nyem rau ntawm lub pob "OK".
- Cov lus muaj nuj nqi pib tshwm. THAUJ. Tsuas cav ntawm tus neeg teb xov tooj no sib raug rau lub teb "Array". Nyob rau hauv nws koj yuav tsum nkag mus rau ib qho chaw ntawm lub cim, uas yuav tsum tau nres. Ua li no, teem caij rau tus cursor hauv lub tshav pob thiab, tuav cov laug nas khawm, xaiv tag nrho cov duab ntawm daim ntawv. Tom qab qhov chaw nyob ntawm qhov chaw nyob hauv cov lus sib tham, nias ntawm lub pob "OK".
- Tab sis, thaum peb pom, hauv xov tooj ntawm tes, uas yog tsim los tso saib qhov tshwm sim, qhov tsis muaj tseeb tus nqi pom tshwm los ua yuam kev "#VALUE!". Qhov no yog vim lub peculiarities ntawm kev ua hauj lwm ntawm array tswv. Txhawm rau kho qhov yuam kev no, xaiv qhov ntau ntawm cov hlwb uas tus lej ntawm cov kab yuav tsum sib npaug zos rau txhua tus kab ntawm daim tseem matrix, thiab cov lej ntawm txhua kab. Xws li kev sib tw yog ib qho tseem ceeb heev rau qhov tshwm sim los ua kom pom tseeb. Nyob rau tib lub sij hawm, lub xov tooj ntawm tes uas muaj qhov qhia tawm "#VALUE!" Nws yuav tsum yog sab saum toj ntawm lub xov tooj ntawm cov khoom raug xaiv, thiab nws yog los ntawm cov txheej txheem kev xaiv yuav pib, tuav khawm nas khawm. Tom qab koj tau xaiv, muab tus cursor tso rau hauv qhov formula formula tam sim ntawd tom qab nqe lus THAUJuas yuav tsum tshwm sim nyob rau hauv nws. Tom qab ntawd, ua tus muab xam, koj yuav tsum tsis txhob nias ntawm lub pob Sau, raws li kev cai nyob rau hauv hom qauv li ib txwm, thiab hu ua ke Ctrl + ua haujlwm + nkag.
- Tom qab cov kev ua no, daim duab no qhia tau tias peb xav tau, uas yog, hauv daim ntawv thim. Tab sis muaj lwm qhov teeb meem. Qhov tseeb yog tias tam sim no tus tshiab matrix yog ib qho array ua ke los ntawm formula uas tuaj yeem hloov tsis tau. Yog hais tias koj sim ua kom muaj kev hloov rau cov ntsiab lus ntawm qhov kev ua tiav, qhov yuam kev yuav nce tuaj. Qee cov neeg siv tau txaus siab hlo nrog lub xeev cov xwm txheej no, raws li lawv tsis mus hloov hauv qhov array, thaum lwm tus xav tau ib daim duab uas koj tuaj yeem ua haujlwm tag nrho.
Yuav kom daws tau qhov teeb meem no, xaiv tag nrho cov kev hloov pauv. Tsiv mus rau lub tab "Tsev" nyem rau ntawm lub cim "Daim qauv"uas yog nyob rau ntawm daim kab xev hauv pawg "Ntawv Teev Npe". Siv qhov kev txiav txim siab ua haujlwm, koj tuaj yeem xaiv tus txheej txheem ntawm lub tshuab luam yeeb tom qab koj xaiv Ctrl + C.
- Tom qab ntawd, tsis tas tshem qhov kev xaiv ntawm qhov sib txuam, nyem rau ntawm nws txoj kev nas khawm. Hauv cov ntawv qhia zaub mov hauv pawg "Insertion Options" nyem rau ntawm lub cim "Qhov tseem ceeb", uas muaj daim ntawv ntawm lub icon nrog cov duab ntawm tus lej.
Nram qab no yog cov qauv mis THAUJ yuav muab deleted, thiab tsuas yog ib tus nqi yuav nyob hauv lub hlwb, uas koj tuaj yeem ua haujlwm tib yam li nrog daim tseem qub.
Tshooj: Excel ua haujlwm wizard
Txoj kev 2: hloov qhov kev siv lub cim tshwj xeeb nrog
Tsis tas li ntawd, hauv daim ntawv xaiv tsa tau muab pov tseg siv ib lub ntsiab lus teb cov lus qhia ua ke, uas hu ua "Muab Tshuaj Rau Tshwj Xeeb".
- Xaiv qhov qub matrix nrog tus cursor, tuav cov laug nas khawm. Tom ntej, mus rau lub tab "Tsev", nyem rau ntawm lub cim "Daim qauv"muab tso rau hauv qhov chaw thaiv "Ntawv Teev Npe".
Xwb, koj tuaj yeem ua nws txawv. Xaiv lub cheeb tsam, nyem rau ntawm nws nrog txoj kev nas khawm. Nws qhib cov ntsiab lus teb uas koj xaiv qhov khoom "Daim qauv".
Raws li ib qho kev hloov mus rau ob qhov kev luam cov kev xaiv yav dhau los, koj tuaj yeem tsim kev xaiv ntawm cov kub kub tom qab xaiv Ctrl + C.
- Peb xaiv rau ntawm daim ntawv ib lub xovtooj npliag, uas yuav tsum tau ua rau sab qis sab laug ntawm qhov hloov thim rov qab. Nias rau ntawm nws nrog txoj kev nas khawm. Nram qab no, lub ntsiab lus teb lus qhia tau qhib. Nyob rau hauv peb peb ua haujlwm ntawm qhov khoom "Muab Tshuaj Rau Tshwj Xeeb". Lwm cov ntawv qhia me me tshwm. Nws kuj muaj lub npe hu ua lus clause "Tshwj xeeb ntxig rau ...". Nias rau nws. Koj tuaj yeem ua, xaiv qhov xaiv, tsis txhob hu rau lub ntsiab lus teb cov lus qhia, ntaus ib qho ua ke ntawm cov keyboard Ctrl + Nres + V.
- Lub qhov rais nruab nrab yog qhib qhov rai. Muaj ntau txoj hau kev xaiv los ntawm, raws nraim li cas koj tuaj yeem paste cov ntaub ntawv luam ua ntej. Nyob rau hauv peb cov ntaub ntawv, koj yuav tsum tawm tawm yuav luag tag nrho cov kev xaiv default. Tsuas yog ze ntawm qhov parameter "Transpose" yuav tsum tau zuam. Ces nyem rau ntawm lub pob. "OK"uas yog nyob hauv qab ntawm qhov rai no.
- Tom qab cov kev ua no, cov thwj thij uas raug xa tawm yuav muab tso rau hauv lub pre-xaiv ntawm daim ntawv. Tsis zoo li yav dhau los, peb twb tau txais ib daim ntawv qhia tag nrho, uas tuaj yeem hloov, zoo li lub hauv paus. Tsis tas yuav tsum tau hloov dua siab tshiab lossis hloov hlo.
- Tab sis yog tias koj xav tau, yog tias koj tsis xav tau qhov tseem ceeb tshaj plaws, koj tuaj yeem muab rho tawm. Ua li no, xaiv nws nrog tus cursor, tuav lub pob nyem khawm. Tom qab ntawd nias rau ntawm cov khoom xaiv uas muaj cai khawm. Hauv cov ntawv qhia zaub mov uas qhib tawm tom qab qhov no, xaiv qhov khoom "Cov lus tseeb".
Tom qab cov kev ua no, tsuas yog cov qauv hloov dua siab tshiab rau hauv daim ntawv.
Los ntawm tib ob txoj kev uas tau tham txog saum toj no, nws muaj peev xwm los hloov tau hauv Excel tsis tsuas yog kev hloov xim, tab sis kuj tag nrho cov ntxhuav. Cov txheej txheem yuav zoo tib yam.
Tshooj: Yuav ua li cas ntxeev lub rooj hauv Excel
Yog li, peb pom tias nyob rau hauv Excel, hauv matrix yuav tau transposed, uas yog, flipped los ntawm kev hloov cov kab thiab kab hauv ob txoj kev. Thawj qhov kev xaiv yog siv qhov kev ua haujlwm THAUJthiab qhov thib ob yog cov cuab yeej tshwj xeeb zoo. By thiab loj, qhov kawg tshwm sim, uas yog tau los ntawm kev siv ob qho tib si ntawm no, yog tsis sib txawv. Ob txoj kev ua haujlwm yuav luag txhua qhov teeb meem. Yog li thaum xaiv ib qhov kev xaiv dua, kev nyiam tus kheej ntawm ib tug neeg siv tau tuaj yeem ua ntej. Ntawd yog, uas ntawm cov hau kev no yooj yim rau koj tus kheej, thiab siv qhov ntawd.
