Dzidza Kuti Ungashandisa sei Excel's TRANSPOSE Function: Flip Rows kana Columns

Shandura nzira iyo data yakarongwa pane pepa rako rekushanda

ICHINYANYA basa iri muExcel nderimwe nzira yekushandura nzira iyo data yakarongwa kana inotungamirirwa mune pepa rekushanda. Basa racho rinofambisa dhesi iri mumitsara kumakoroni kana kubva kumadzorodho kusvika kumitsara. Basa racho rinogona kushandiswa kudhinda mutsara mumwechete kana koromo yedata kana mutsara wakawanda kana koromo.

01 ye 02

KUTSANYA Nhengo yeSintax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Izwi rechiito che TRANSPOSE basa nderokuti:

{= KUTANGA (Array)}

Mhando ndeyera yemasero inofanira kunyorwa kubva mumuganhu kusvika munhare kana kubva kune imwe column kusvika mumutsara.

• Ukuru hwemapuranga ekutanga uye matsva anofanira kufanana. Kana iyo yepakutanga ine mishanu masero e data mumutsetse, mutsva unofanirwa kuva nemasero mashanu e data mushure.
• Kana mutsara yakawanda-chinyorwa ichidhindwa, kora yekutanga yeyara inova mutsara wekutanga we mutsva wekutanga, chikamu chechipiri chetara chinova mutsara wechipiri wezvitsva zvitsva, nezvimwe zvakadaro. Izvo zvinoitika kana mutsara wemutsetse unoshandiswa.

CSE Formula

Izvo zvakanyanyisa (} zvakapoteredza basa zvinoratidza kuti iyo nzira yakasiyana . Nzira yakagadzirirwa inogadzirwa nokudhinda Ctrl , Shift , uye Enter keys pane keyboard panguva imwechete paunopinda mufomu.

Nzira yakagadziriswa inofanira kushandiswa nokuti CHITENDE chinoshanda chinofanira kuiswa mukati memasero panguva imwechete kuti data igoverwa kubudirira.

Nemhaka yekuti mazano akaumbwa anoshandiswa achishandisa Ctrl , Shift , uye Enter key, dzinowanzozivikanwa seCSE mazano.

02 of 02

Transposing Rows to Columns Example

Muenzaniso uyu unobatanidza nzira yekupinda muTARANSPOSE array formula iri muchitokisi C1 kusvika kuG1 yemufananidzo unofambisa nenyaya ino. Matanho mamwechete anoshandiswawo kupinda muchipiri TRANSPOSE array formula iri mumasero E7 kusvika kuG9.

Kupinda DHANDI YOMUSORO

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana: = KUTENDA (A1: A5) mumasero C1: G1
2. Kusarudza basa uye nharo dzayo uchishandisa TRANSPOSE basa dialog box

Kunyange zvazvo zvichikwanisika kunyora basa rakakwana nemunhu, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi nokuti rinotarisira kupinda mumashandisirwo emasikirwo akadai seakakani uye vheji yevatengesi pakati pemakakatanwa.

Hazvina mhosva kuti nzira ipi inoshandiswa kupinda murairo, danho rekupedzisira - iro rekushandura iro romufananidza - inofanira kuitwa nemaCtrl , Shift , uye Enter keys.

Kuzarura TRANSPOSE Dialog Box

Kuisa TRANSPOSE basa mumasero C1 kusvika kuG1 uchishandisa basa rebhokisi rebhokisi:

1. Simbisai masero C1 kusvika kuG1 mubasa rekushanda;
2. Dzvanya paMafomu tab yebhoni;
3. Dzvanya paLookup uye Referenti icon kuti uzarure basa rekuderedza pasi;
4. Dzvanya pa TRANSPOSE mune urongwa kuti uzarure bhokisi rebasa rebasa.

Kupinda Mukana Wokukwirirana uye Kugadzira Romu Formula

1. Simbisai masero A1 kusvika kuA5 pane pepa rekushandisa kuti uise iri bhanhire seArray argument.
2. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
3. Dhinda uye usunungurire muIno yekupinda pane kadhibhodi kuti upinde TRANSPOSE basa seurongwa hwemavara mumasero ose mashanu.

Nhamba iri mumasero A1 kusvika kuA5 inofanira kuonekwa mumasero C1 kusvika kuG1.

Kana iwe ukanyora pane chero masero ari mumakamuri eC1 kusvika kuG1, basa rakakwana {= TRANSPOSE (A1: A5)} rinowanikwa mubhairi yepamusoro pane pepa pepaji.