Funda indlela yokusebenzisa i-Excel's TRANSPOSE Function: Flip Rows noma Columns

Shintsha indlela idatha ehlelwe ngayo ekhasini lakho lokusebenzela

Umsebenzi we-TRANSPOSE ku-Excel kuyindlela eyodwa yokushintsha indlela idatha ehlelwe ngayo noma eqondiswe kushidi lokusebenzela. Umsebenzi ugoqa idatha egciniwe kumakholomu noma kusukela kumakholomu kuya emigqeni. Umsebenzi ungasetshenziselwa ukudlulisa umugqa owodwa noma ikholomu yedatha noma uhlu olubanzi lwamakholomu noma ikholomu.

01 ngo-02

I-Syntax ne-Arguments ye-Function

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax ye-TRANSPOSE umsebenzi yilezi:

{= I-TRANSPOSE (i-Array)}

I-array ibanga lamaseli okufanele akopishwe kusuka emgqeni abe yikholomu noma kusukela kukholomu ibe yinqolo.

• Ubukhulu bezingxenye zangaphambili nezisha kufanele zihambisane. Uma uhlu oluqala luqukethe amaseli amahlanu wedatha kukholomu, uhlu olusha kufanele luqukathe amaseli amahlanu wedatha ngokulandelana.
• Uma uhlu lwamakholomu amaningi luhanjiswa, ikholomu yokuqala yohlu iba umugqa wokuqala wohlu olusha, ikholomu yesibili yomugqa iba umugqa wesibili wohlu olusha, njalo njalo. Okufanayo kwenzeka uma i-multi-row array ishintshiwe.

I-CSE Ifomula

Ama-curly curly {} azungeze lo msebenzi abonisa ukuthi ifomula yamalungu . Ifomula eqondile idalwe ngokucindezela okhiye be- Ctrl , Shift , no- Enter ekhibhodi ngesikhathi esifanayo uma ufaka ifomula.

Ifomula eqondile kufanele isetshenziswe ngoba umsebenzi we-TRANSPOSE udinga ukungena kubanga lamaseli ngesikhathi esisodwa ukuze idatha iphotshwe ngempumelelo.

Ngenxa yokuthi amafomu amafomu adalwa asetshenziswa ngokusebenzisa izikhiye ze- Ctrl , Shift , no- Enter , zivame ukubizwa ngokuthi ama-CSE amafomula.

02 ka 02

Ukudlulisela imigqa kuya ku-Columns Isibonelo

Lesi sibonelo sibheka indlela yokungena ifomula ye-TRANSPOSE array esesitokisini C1 kuya ku-G1 yesithombe esihambisana nalesi sihloko. Izinyathelo ezifanayo nazo zisetshenziselwa ukungena ekhondomu yesibili ye-TRANSPOSE elayini e-E7 kuya ku-G9.

Ukufaka umsebenzi we-TRANSPOSE

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

1. Ukuthayipha umsebenzi ophelele: = TRANSPOSE (A1: A5) kumaseli C1: G1
2. Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lengxoxo ye- TRANSPOSE ibhokisi

Nakuba kungenzeka ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lebhokisi ngoba liyakhathalela ukungena kwi-syntax yomsebenzi njengabakaki kanye nabahlukanisi be-comma phakathi kwama-arguments.

Kungakhathaliseki ukuthi iyiphi indlela esetshenziselwa ukungena ifomula, isinyathelo sokugcina - sokuyijika ibe yifomula yamalungu - kufanele kwenziwe ngesandla ngamakhikhi e - Ctrl , Shift , no- Enter .

Ukuvula ibhokisi le-TRANSPOSE Dialog

Ukufaka umsebenzi we-TRANSPOSE kumaseli C1 kuya ku-G1 usebenzisa ibhokisi lengxoxo lomsebenzi:

1. Qinisekisa amaseli C1 kuya ku- G1 ekhasini lokusebenzela;
2. Chofoza kuthebhu yefomu yebhebhoni;
3. Chofoza ku-icon ye- Lookup ne-Reference ukuze uvule uhlu lokudonsa phansi lomsebenzi;
4. Chofoza ku- TRANSPOSE ohlwini ukuze uvule ibhokisi lengxoxo lomsebenzi.

Ukufaka i-Array Argument nokudala ifomu ye-Array

1. Qinisekisa amaseli A1 kuya ku- A5 kusikripthi sokusebenza ukuze ufake lolu hlu njenge- Array argument.
2. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
3. Cindezela bese ukhulula ukhiye we- Enter ekhibhodi ukungena umsebenzi we-TRANSPOSE njengendlela yefomula yamagama kuwo wonke amaseli amahlanu.

Idatha kumaseli A1 kuya ku-A5 kufanele avele kumaseli C1 kuya ku-G1.

Uma uchofoza kunoma yiliphi lamaseli ku-range C1 kuya ku-G1, umsebenzi ophelele {= TRANSPOSE (A1: A5)} uvela kubha yefomula ngaphezulu kwephepha lokusebenzela.