Transpose matrix mu Microsoft Excel

Mukamagwira ntchito ndi matrices, nthawi zina muyenera kuwasintha, ndiye kuti, m'mawu osavuta, atembenuzireni. Zachidziwikire, mutha kupha data pamanja, koma Excel imapereka njira zingapo kuti ikhale yosavuta komanso yachangu. Tiyeni tiwapende mwatsatanetsatane.

Ntchito yopanga

Kusintha kwa matrix ndi njira yosinthira mizati ndi mizere. Excel ali ndi njira ziwiri zosinthira: kugwiritsa ntchito ntchito KUTENGA kugwiritsa ntchito chida chofunikira kwambiri. Onani njira zonsezi mwatsatanetsatane.

Njira 1: Wothandizira wa TRANSPOSE

Ntchito KUTENGA ali m'gulu la ogwiritsira ntchito Malingaliro ndi Kufika. Chachilendo ndichakuti, monga ntchito zina zomwe zimagwira ntchito ndi masanjidwe ena, zotulukapo sizomwe zili m'chipindacho, koma zambiri. Kapangidwe ka ntchitoyo ndi kosavuta ndipo kamawoneka motere:

= TRANSPOSE (mndandanda)

Ndiye kuti, kukangana kokhako kwa operekera ntchitoyi kukukhudza mndandanda, ife, matrix osinthika.

Tiyeni tiwone momwe ntchitoyi ingagwiritsidwire ntchito pogwiritsa ntchito chitsanzo ndi matrix enieni.

1. Timasankha khungu lopanda chilichonse pa pepalali, lomwe limakonzedwa kuti lipangidwe ndi khungu lapamwamba kwambiri lamanzere la matrix osandulika. Chotsatira, dinani pazizindikiro "Ikani ntchito"lomwe lili pafupi ndi mzere wa fomula.



2. Kuyambira Ogwira Ntchito. Timatsegula gulu mmenemo Malingaliro ndi Kufika kapena "Mndandanda wathunthu wa zilembo". Atapeza dzinalo TRANSP, sankhani ndikudina batani "Zabwino".



3. Ntchito yotsutsana ndi ntchito imayamba. KUTENGA. Kutsutsana kokhako kwa ogwiritsira ntchito ndi gawo Menya. Ndikofunikira kulowa pazogwirizira za matrix, zomwe zimayenera kutembenuzidwira. Kuti muchite izi, ikani cholozera m'munda ndipo, ndikusunga batani lakumanzere, sankhani masanjidwe onsewo papepala. Pambuyo adilesi ya chigawo chikuwonetsedwa pazenera zotsutsana, dinani batani "Zabwino".



4. Koma, monga mukuwonera, mu khungu lomwe limapangidwa kuti liwonetse zotsatira, mtengo wolakwika umawonetsedwa molakwika "#VALUE!". Izi ndichifukwa chazovuta zakugwirira ntchito kwa magulu ambiri. Kuti tikonze vutoli, timasankha maselo angapo momwe kuchuluka kwa mizere kuyenera kukhala kofanana ndi kuchuluka kwa mizati yoyambirira matrix, ndi kuchuluka kwa mzati mpaka chiwerengero cha mizere. Masewera oterewa ndikofunikira kwambiri kuti zotsatira zake ziwonetsedwe moyenera. Poterepa, khungu lomwe lili ndi mawuwo "#VALUE!" ikuyenera kukhala khungu lamanzere lamanzere la mitundu yosankhidwayo ndipo kuchokera pamenepo kuti njira yosankhayo iyenera kuyambitsidwa ndikusunga batani lakumanzere. Mukasankha, ikani chikhazikitso mu baramu yokhazikika mukangomaliza kugwiritsa ntchito KUTENGAzomwe zikuyenera kuwonetsedwa mmenemo. Pambuyo pake, kuti muwerengere, muyenera dinani osati batani Lowanimwachizolowezi monga momwe mumagwiritsira ntchito masiku onse, ndikuyimba kuphatikiza Ctrl + Shift + Lowani.



5. Pambuyo pa izi, matrix adawonetsedwa momwe timafunikira, ndiye kuti, mawonekedwe otayika. Koma pali vuto linanso. Chowonadi ndi chakuti tsopano matrix yatsopano ndi gulu lomwe limalumikizidwa ndi formula yomwe singasinthidwe. Mukamayesetsa kusintha zina ndi zomwe zili m'matumbo, cholakwika chimayamba. Izi ndizabwino kwambiri kwa ogwiritsa ntchito, chifukwa sakusintha mndandanda, koma ena amafunikira matrix omwe angagwire nawo ntchito mokwanira.

   Kuti muthane ndi vutoli, sankhani magulu onse omwe asinthidwa. Kusamukira ku tabu "Pofikira" dinani pachizindikiro Copyili pa tepi mgululi Clipboard. M'malo mwa chochitikacho, mutatha kuwunikira, mutha kupanga njira zazifupi zokhazokha kuti muzitsatira Ctrl + C.



6. Kenako, osachotsa masankhidwewo pamtundu wosinthidwa, dinani ndi batani loyenera la mbewa. Pazosankha zam'maguluwo Ikani Zosankha dinani pachizindikiro "Makhalidwe", yomwe ili ndi mawonekedwe ojambulidwa ndi chithunzi cha manambala.

   

   Kutsatira ndi njira iyi KUTENGA idzachotsedwa, ndipo mtengo umodzi wokha ukatsalira m'maselo, momwe mutha kugwirira ntchito mofananamo ndi matrix oyambirirawo.

Phunziro: Excel Feature Wizard

Njira 2: thirani matrix pogwiritsa ntchito kofunikira

Kuphatikiza apo, matrix amatha kusinthidwa pogwiritsa ntchito chinthu chimodzi cha menyu yazonse, yomwe imatchedwa "Lowetsani mwapadera".

1. Sankhani choyambirira matrix ndi cholozera, chogwirizira batani lakumanzere. Chotsatira, kupita ku tabu "Pofikira"dinani pachizindikiro Copyili mu blockchain Clipboard.

   

   M'malo mwake, zitha kuchitidwa mosiyanasiyana. Popeza tidasankha malowa, timadina ndi batani la mbewa yoyenera. Zosintha zamakina ndi zoyendetsedwa, zomwe muyenera kusankha Copy.

   

   Monga njira ina yomwe mungasankhe pamakopi awiri apitayo, mutatsindika, mutha kupanga mitundu yayikulu ya hotkey Ctrl + C.

2. Timasankha cholembera papepala, chomwe chizikhala chofunikira kwambiri kumanzere kwa matrix omwe atumizidwa. Dinani pa icho ndi batani la mbewa yoyenera. Kutsatira izi, menyu yazonse zimayambitsidwa. Mmenemo, timayendayenda mozungulira chinthucho "Lowetsani mwapadera". Zakudya zina zazing'ono zikuwonekera. Ilinso ndi chinthu chotchedwa "Ikani mwapadera ...". Dinani pa izo. Mukhozanso, mutasankha, m'malo mwayitanitsa menyu wazakudya, lembani chophatikizira pazibatani Ctrl + Alt + V.



3. Windo lolowetsa lapadera limagwira. Pali zosankha zambiri pakusankha momwe mungalembere deta yomwe idakopedwa kale. M'malo mwathu, muyenera kusiya pafupifupi zosintha zonse. Pafupifupi chizindikiro "Transpose" Chongani bokosi. Kenako muyenera dinani batani "Zabwino", yomwe ili pansi pazenera ili.



4. Pambuyo pa izi, matrix omwe adasinthidwa amawonetsedwa gawo lomwe lisanachitike. Mosiyana ndi njira yapita, talandira kale matrix omwe ali ndi matilesi omwe amatha kusinthidwa, ngati gwero. Palibe kukonza kapena kusinthanso kwina komwe kumafunikira.



5. Koma ngati mukufuna, ngati simukufuna choyambirira matrix, mutha kuchotsa. Kuti muchite izi, sankhani ndi cholozera, chogwirizira batani lakumanzere. Kenako dinani pazosankhidwa ndi batani loyenera. Pazosankha zomwe zitsegulidwa pambuyo pa izi, sankhani Chotsani Zolemba.

Pambuyo pa izi, matrix osandulika okha ndi omwe angatsalire pepala.

Munjira ziwiri zomwe, zomwe tidakambirana pamwambapa, ndizotheka kuyika mu Excel osati matrices okha, komanso matebulo athunthu. Ndondomeko zikhala zofanana.

Phunziro: Momwe mungatsegule tebulo ku Excel

Chifukwa chake, tidazindikira kuti ku Excel masanjidwewo amatha kusunthidwa, ndiye kuti, nkuwuluka ndi kusintha zipilala ndi mizere m'njira ziwiri. Njira yoyamba ikuphatikiza ntchito KUTENGAchachiwiri ndi zida zapadera zolowetsera. Kwakukulu, zotsiriza zomwe zimapezeka pogwiritsa ntchito njirazi zonse sizili zosiyana. Njira zonsezi zimagwira ntchito nthawi iliyonse. Chifukwa chake posankha njira yosinthira, zomwe munthu amakonda zodziwikiratu zimabwera. Ndiye kuti, ndi iti mwa njira izi yomwe ili yabwino kwambiri kwa inu, gwiritsani ntchitoyo.