Ithute ho sebelisa Excel's TRANSPOSE Function: Flip Rows kapa Columns

Fetola tsela eo data e behiloeng ka eona leqepheng la hau la mosebetsi

The TRANSPOSE function in Excel ke kgetho e le nngwe ea ho fetola tsela eo data e behiloeng ka eona kapa e shebisitsoeng leqepheng la mosebetsi . Mosebetsi o flips data e arolelanoang melaong kapa ho tloha melaong ho ea ho mela. Mosebetsi o ka sebelisoa ho fetisa mola o le mong kapa kholumo ea data kapa mola o mongata kapa mebala e mengata .

01 ea 02

HO HLOKAHALA Mantsoe a Syntax le Liqeto

Syntax ea mosebetsi e bua ka boemo ba mosebetsi mme o kenyelletsa lebitso la mosebetsi, li-brackets le likhang .

Tlhaloso ea TRANSPOSE mosebetsi ke:

{= TRANSPOSE (Array)}

Sehlopha ke lisele tsa lisele tse lokelang ho kopitsoa ho tloha mohloling ho ea ho khoeli kapa ho tloha ho khoeli ho ea ka tatellano.

• Boholo ba li-arrays tsa pele le tse ncha li lokela ho lumellana. Haeba karolo ea mathomo e na le lisele tse hlano tsa lintlha tse ka kholeng, sehlopha se secha se tlameha ho na le lisele tse hlano tsa data ka tatellano.
• Haeba sehlopha sa li-column tse ngata se fetisetsoa, ​​mohala oa pele oa sebaka e ba moqolo oa pele oa mocha o mocha, moloko oa bobeli oa sehlopha o fetoha mola oa bobeli oa sehlopha se secha, joalo-joalo. Hoa tšoana le haeba sehlopha sa mefuta e mengata se fetisitsoe.

CSE Formula

Li-braces { curly } tse pota-potileng mosebetsi li bontša hore ke mokhoa o fapaneng . Mokhoa o motlakase o entsoe ka ho hatisa linotlolo tsa Ctrl , Shift , le Enter ka lebokose ka nako e ts'oanang ha u kena ka foromo.

Morero o lokela ho sebelisoa hobane mosebetsi oa TRANSPOSE o lokela ho kenngoa ka liseleng tse ngata ka nako e le nngwe bakeng sa hore data e fokotsehe ka katleho.

Hobane mefuta e mengata e sebelisoa ho sebelisoa linotlolo tsa Ctrl , Shift , le Enter , hangata li bitsoa litlhahlobo tsa CSE.

02 ea 02

Ho fetisetsa meeli ho li-Columns mohlala

Mohlala ona o akaretsa mokhoa oa ho kenya moralo oa TRANSPOSE o hlahang seleng ea C1 ho G1 ea setšoantšo se tsamaeang le sehlooho sena. Mehato e ts'oanang e boetse e sebelisoa ho kenya mohoeletsi oa bobeli oa TRANSPOSE ka liseleng tsa E7 ho ea ho G9.

Ho kenya mosebetsi oa TRANSPOSE

Dikgetho bakeng sa ho kena mosebetsing le mabaka a eona a kenyeletsa:

1. Tšoara mosebetsi o feletseng: = TRANSPOSE (A1: A5) ka liseleng tsa C1: G1
2. Ho khetha mosebetsi le mabaka a oona ho sebelisa TRANSPOSE function dialog box

Le hoja ho ka khoneha ho thaepa mosebetsi o feletseng, batho ba bangata ba fumana ho le bonolo ho sebelisa lebokose la lebokose hobane le hlokomele ho kena ka syntax ea mosebetsi e kang likereke le likarohano tsa lihlahisoa pakeng tsa likhang.

Ho sa tsotellehe hore na mokhoa ofe o sebelisetsoang ho kenya mochine ona, mohato oa ho qetela - oa ho o fetisetsa ka mokhoa o fapaneng - o lokela ho etsoa ka letsoho le likheo tsa Ctrl , Shift , le Enter .

Ho bula lebokose la lebokose la TRANSPOSE

Ho kenya mosebetsi oa TRANSPOSE liseleng tsa C1 ho G1 ho sebelisa lebokose la lebokose la mosebetsi:

1. Totobatsa lisele tsa C1 ho G1 kahare ho leqephe;
2. Tobetsa Letomong tab ea lente;
3. Tobetsa letšoao la Lookup le Reference bakeng sa ho bula lenane la ho theoha mosebetsing;
4. Tobetsa ho TRANSPOSE lenaneong la ho bula lebokose la lebokose la mosebetsi.

Ho kenyelletsa Khohlano ea Mathata le Ho theha Formule ea Matsoho

1. Totobatsa lisele tsa A1 ho A5 leqepheng la mosebetsi oa ho kena boemong bona e le khang ea Array .
2. Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng.
3. Tlanya le ho lokolla konopo ea ho kena ka lebokoseng ho kenya mosebetsi oa TRANSPOSE e le mokhoa o fapaneng lisele tse hlano.

Boitsebiso ka liseleng tsa A1 ho A5 bo lokela ho hlaha liseleng tsa C1 ho G1.

Ha o tobetsa lisele leha e le life tse ka hare ho C1 ho G1, mosebetsi o feletseng {= TRANSPOSE (A1: A5)} o hlaha kahare ea foromo ka holim'a leqephe.