Chokwadi mushandisi wese ari kushanda muExcel akasangana nemamiriro ezvinhu apo mitsara nemakoramu etafura zvinoda kuchinjaniswa. Kana isu tichitaura nezve data shoma, iyo nzira inogona kuitwa nemaoko, uye mune dzimwe nguva, kana paine ruzivo rwakawanda, maturusi akakosha anozobatsira zvakanyanya kana kutonyanya kukosha, izvo zvaunogona kushandura tafura otomatiki. . Ngationei kuti zvinoitwa sei.
Tafura transposition
Shanduko - iyi ndiyo "kuchinjisa" kwemitsara uye makoramu etafura munzvimbo. Kuvhiya uku kunogona kuitwa nenzira dzakasiyana.
Nzira 1: Shandisa Paste Special
Iyi nzira inoshandiswa kazhinji, uye hezvino izvo zvinosanganisira:
- Sarudza tafura nenzira ipi zvayo yakanakira (semuenzaniso, nekubata pasi bhatani rekuruboshwe kubva kumusoro kuruboshwe rusero kuenda kuzasi kurudyi).
- Iye zvino tinya-kurudyi pane yakasarudzwa uye sarudza murairo kubva pane yemukati menyu inovhura. "Kopa" (kana kuti panzvimbo pezvo ingo dzvanya musanganiswa Ctrl + C).
- Pane imwechete kana pane rimwe pepa, tinomira muchitokisi, inova sero repamusoro kuruboshwe retafura yakashandurwa. Isu tinya-kurudyi pairi, uye panguva ino isu tinoda iyo rairo mune yemukati menyu "Special Paste".
- Muhwindo rinovhurwa, tarisa bhokisi riri pedyo "Transpose" uye baya OK.
- Sezvatinoona, tafura yakadzoserwa otomatiki yakaonekwa munzvimbo yakasarudzwa, umo makoramu etafura yekutanga akava mitsara uye zvinopesana. Iye zvino tinogona kutanga kugadzirisa kutaridzika kwe data kune zvatinoda. Kana tafura yepakutanga isingachadiwi, inogona kubviswa.
Iye zvino tinogona kutanga kugadzirisa kutaridzika kwe data kune zvatinoda. Kana tafura yepakutanga isingachadiwi, inogona kubviswa.Nzira 2: Isa iyo "TRANSPOSE" Basa
Kuti flip tafura muExcel, unogona kushandisa yakakosha basa "TRANSP".
- Pabepa, sarudza mutsara wemasero ane mitsara yakawanda seine makoramu mutafura yepakutanga, uye maererano naizvozvo, zvakafanana zvinoshanda kumakoramu. Wobva wadzvanya bhatani "Isa basa" kuruboshwe rweformula bar.
- Mune yakavhurwa Basa Wizard sarudza chikamu “Runyorwa ruzere rwearufabheti”, tinowana mushandisi "TRANSP", imaka uye tinya OK.
- Iro hwindo rekupokana kwemabasa richaonekwa pachiratidziri, kwaunoda kutsanangura marongero etafura, pahwaro hwekuti iyo transposition ichaitwa. Iwe unogona kuita izvi nemaoko (keyboard entry) kana nekusarudza huwandu hwemasero papepa. Kana zvese zvagadzirwa, tinya OK.
- Isu tinowana iyi mhedzisiro papepa, asi handizvo zvese.
- Zvino, kuitira kuti tafura yakachinjirwa ioneke pachinzvimbo chekukanganisa, tinya pane formula bar kuti utange kugadzirisa zvirimo, isa chitubu kumagumo, wobva wadzvanya kiyi musanganiswa. Ctrl + Shift + Pinda.
- Nokudaro, takakwanisa kubudirira kushandura tafura yepakutanga. Mubhawa reformula, tinoona kuti kutaura kwacho kwave kuumbwa nema curly braces.Cherechedza: Kusiyana nenzira yekutanga, iyo yekutanga fomati haina kuchengetedzwa pano, iyo mune dzimwe nguva yakatonaka, sezvo isu tichigona kuseta zvese kubva mukutanga nzira yatinoda. Zvakare, pano isu hatina mukana wekudzima tafura yepakutanga, sezvo basa "rinodhonza" data kubva mairi. Asi iyo isina mubvunzo mukana ndeyekuti matafura akabatana, kureva chero shanduko kune yepakutanga data ichakurumidza kuratidzwa mune iyo transposed.
Cherechedza: Kusiyana nenzira yekutanga, iyo yekutanga fomati haina kuchengetedzwa pano, iyo mune dzimwe nguva yakatonaka, sezvo isu tichigona kuseta zvese kubva mukutanga nzira yatinoda. Zvakare, pano isu hatina mukana wekudzima tafura yepakutanga, sezvo basa "rinodhonza" data kubva mairi. Asi iyo isina mubvunzo mukana ndeyekuti matafura akabatana, kureva chero shanduko kune yepakutanga data ichakurumidza kuratidzwa mune iyo transposed.mhedziso
Saka, pane nzira mbiri dzaungashandisa kufambisa tafura muExcel. Ose ari maviri ari nyore kuita, uye kusarudzwa kweimwe kana imwe sarudzo kunoenderana nezvimwe zvirongwa zvekushanda neyekutanga uye yakagamuchirwa data.