Koyi Yadda za a Yi amfani da Ayyukan Fassara na Excel: Fassara Rukunai ko ginshiƙai

Canja hanyar da aka ba da bayanai a kan takardar shaidarku

Ayyukan TRANSPOSE a Excel shine zaɓi guda daya don canza hanyar da aka ba da bayanai a cikin takaddun aiki. Ayyukan watsa bayanai suna samuwa a layuka zuwa ginshiƙai ko daga ginshiƙai zuwa layuka. Ana iya amfani da aikin don sauya jere guda ko shafi na bayanai ko jere ko jeri .

01 na 02

Sanya Hanya da Magana game da aiki

Flipping Data daga ginshikan zuwa Rows tare da aikin TRANSPOSE. © Ted Faransanci

Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .

Hadawa don aikin TRANSPOSE shine:

{= SANYARWA (Gida)}

Rundin yana da kewayon kwayoyin don a kwafe daga jere cikin shafi ko daga shafi a layi.

CASE Formula

Gwanin gyare-gyare {} kewaye da aikin ya nuna cewa wannan tsari ne . An kirkiro takarda tsararren ta latsa Ctrl , Shift , kuma Shigar da maɓallan akan keyboard a lokaci guda lokacin shigar da tsari.

Dole ne a yi amfani da takaddamar tsari don aikin TRANSPOSE yana buƙatar shiga cikin sassan kwayoyin halitta a lokaci guda don bayanan da aka samu.

Domin an tsara siffofin tsararren ta amfani da Ctrl , Shift , kuma Shigar da maɓallai, ana kiran su a matsayin CSE.

02 na 02

Harshen Juyawa zuwa ginshiƙai Misali

Wannan misali ya hada da yadda za a shigar da matakan TRANSPOSE wanda ke cikin tantanin halitta C1 zuwa G1 na hoton da ke bin wannan labarin. Ana amfani da wannan matakan don shigar da tsarin na biyu TRANSPOSE wanda aka samo a cikin kwayoyin E7 zuwa G9.

Shigar da aikin TRANSPOSE

Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:

  1. Rubuta cikakken aikin: = SASHI (A1: A5) cikin sassan C1: G1
  2. Zabi aikin da kuma muhawarar ta amfani da akwatin kwaminar TRANSPOSE aiki

Ko da yake yana yiwuwa a rubuta aikin cikakke tare da hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu saboda yana kula da shigar da haɗin aiki kamar sakonni da rabuwa tsakanin ɓangarori.

Kowace hanya aka yi amfani da shi don shigar da tsari, mataki na ƙarshe - wato juya shi a cikin tsari mai tsafta - dole ne a yi tare da hannu tare da Ctrl , Shift , kuma Shigar da maɓallai.

Gudun Akwatin Gida ta TRANSPOSE

Don shigar da aikin TRANSPOSE cikin sassan C1 zuwa G1 ta amfani da akwatin maganganun aikin:

  1. Sanya sassa C1 zuwa G1 a cikin takardun aiki;
  2. Danna kan Rubutun hanyoyin shafin rubutun;
  3. Danna maɓallin Ganowa da Magana don buɗe jerin abubuwan da aka sauke.
  4. Danna danna TRANSPOSE cikin jerin don bude akwatin maganganun.

Shigar da Maganar Array da Halitta Tsarin Rage

  1. Sanya siffofin A1 zuwa A5 a kan takardar aiki don shigar da wannan kewayon azaman Array hujja.
  2. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard.
  3. Latsa kuma saki maɓallin shigarwa a kan keyboard don shigar da aikin TRANSPOSE a matsayin tsari mai tsafta a cikin dukkanin biyar.

Bayanai a cikin sel A1 zuwa A5 ya kamata ya bayyana a cikin kwayoyin C1 zuwa G1.

Lokacin da ka danna kan kowane ɓangaren da ke cikin kewayon C1 zuwa G1, aikin cikakke {= TRANSPOSE (A1: A5)} ya bayyana a cikin maɓallin tsari a sama da takardun aiki.