Phunzirani momwe mungagwiritsire ntchito TRELSPOSE ya Excel Function: Flip Rows kapena Columns

Sinthani njira yomwe deta yakhalira pa tsamba lanu

Zomwe zimagwira ntchito ku Excel ndi njira imodzi yosinthira momwe deta yakhalira kapena yowongoka pa tsamba. Ntchitoyi ikuwombera deta yomwe ili m'mizere kuzitsulo kapena kuchokera pazitsulo mpaka mizere. Ntchitoyi ingagwiritsidwe ntchito kutsegula mzere umodzi kapena deta ya deta kapena mzere wambiri kapena mndandanda wambiri .

01 a 02

ZINTHU ZOYENERA KUTSATIRA Msonkhano wa Syntax ndi Maganizo

Kupukuta Dongosolo kuchokera ku Mizere mpaka Mizere ndi Ntchito TRANSPOSE. © Ted French

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha TRANSPOSE ntchito ndi:

{= TRANSPOSE (Mzere)}

Mndandanda ndi maselo ambirimbiri omwe ayenera kuponyedwa kuchokera mzere kukhala mndandanda kapena kuchokera pa khola kupita mzere.

CSE Mpangidwe

Mitsempha yowongoka {} yozungulira ntchitoyo ikusonyeza kuti ndi njira yowonjezera . Mndandanda wamtunduwu umapangidwira makina a Ctrl , Shift , ndi Enter mu khibodi panthawi imodzimodziyo polowa mndandanda.

Njira yowonjezera iyenera kugwiritsidwa ntchito chifukwa ntchito YOPHUNZITSIRA imayenera kuikidwa m'maselo osiyanasiyana panthawi imodzimodzi kuti deta ipambane mofulumira.

Chifukwa mitundu yowonjezera imapangidwa pogwiritsa ntchito makiyi a Ctrl , Shift , ndi Enter , nthawi zambiri amatchedwa ma CSE ma formula.

02 a 02

Kutumizira Mizere kwa Ma Columns Chitsanzo

Chitsanzo ichi chimaphatikizapo momwe mungalowerere ndondomeko ya TRANSPOSE yomwe ili mu selo C1 mpaka G1 ya chithunzi chomwe chili ndi nkhaniyi. Miyendo yomweyo imagwiritsidwanso ntchito polowera njira yachiwiri ya TRANSPOSE yomwe ili m'maselo E7 mpaka G9.

Kulowa Ntchito YOTSATIRA

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

  1. Kujambula ntchito yonse: = TRANSPOSE (A1: A5) mu maselo C1: G1
  2. Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito TRANSPOSE ntchito dialog box

Ngakhale kuti n'zotheka kulembetsa ntchito yonseyo pamanja, anthu ambiri amavutika kuti agwiritse ntchito bokosilo chifukwa zimasamala kuti alowe m'ma syntax monga mabakiteriya ndi ogawanikana pakati pa zifukwa.

Ziribe kanthu njira yomwe imagwiritsiridwa ntchito kulowetsa ndondomekoyi, sitepe yotsiriza - ya kuyisandutsa iyo ndondomeko yambiri - iyenera kuchitidwa pamanja ndi makina a Ctrl , Shift , ndi Enter .

Kutsegula BUKHU LOTENGA LOGWIRITSA

Kulowa ntchito YOTSATIRA mu maselo C1 mpaka G1 pogwiritsa ntchito bokosi la zokambirana:

  1. Onetsetsani maselo C1 mpaka G1 mu tsamba la ntchito;
  2. Dinani pa Fomu tab ya riboni;
  3. Dinani pazithunzi za Lookup ndi Reference kuti mutsegule ntchito yolemba pansi;
  4. Dinani pa TRANSPOSE mndandanda kuti mutsegule dialog box.

Kulowetsani Mzere Wotsutsana ndi Kupanga Mzere Wopangira

  1. Onetsetsani maselo A1 mpaka A5 pa tsamba kuti mulowetse mndandanda uwu ngati mtsutso wa Array .
  2. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.
  3. Koperani ndi kumasula fungulo lolowamo mu khibhodi kuti mulowetse ntchito YOTSATIRA ngati njira yowonjezera mu maselo asanu.

Deta m'maselo A1 mpaka A5 iyenera kuoneka m'maselo C1 mpaka G1.

Mukamalemba pa maselo onse a C1 mpaka G1, ntchito yonse {= TRANSPOSE (A1: A5)} imapezeka muzenera zamatabwa pamwamba pa tsamba.