Haɓakar bayanai a cikin Excel - yadda ake yin, da menene buƙatun tebur

Ƙirƙirar bayanai wani fasali ne a cikin Excel, godiya ga wanda masu amfani ke da damar haɗa bayanai daga tebur da yawa zuwa ɗaya, da kuma haɗa zanen gado waɗanda suke cikin fayiloli iri ɗaya ko daban-daban zuwa ɗaya.

Abubuwan buƙatun hukuma don tebur waɗanda ke da mahimmanci don kammala haɓakawa

Zaɓin da ake kira "Consolidate" ba zai yi aiki ba idan teburin ba su cika buƙatun ba. Don samun nasarar kammala aikin haɗa bayanai, dole ne ku:

• duba tebur don layuka/ginshiƙai marasa komai kuma a goge su idan akwai;
• yi amfani da samfuri iri ɗaya;
• bi sunayen ginshiƙan, kada su bambanta.

Hanyoyin Haɗin Kan Asali a cikin Excel

Lokacin tattara bayanai daga rahotanni daban-daban, teburi, jeri iri ɗaya zuwa fayil gama gari, zaku iya amfani da hanyoyi daban-daban. Za a tattauna manyan hanyoyi guda biyu na taƙaita bayanai a ƙasa: ta matsayi da kuma rukuni.

• A cikin bambance-bambancen farko, bayanan da ke cikin yankuna na asali suna cikin tsari iri ɗaya wanda ake amfani da lakabi iri ɗaya. Mirgine sama da matsayi don haɗa bayanai daga zanen gado 3-4 waɗanda suka dogara akan samfuri ɗaya, alal misali, bayanan kuɗi sun dace don bincika wannan hanyar.
• A cikin zaɓi na biyu: bayanan suna cikin bazuwar tsari, amma suna da alamomi iri ɗaya. Haɓaka ta nau'i don haɗa bayanai daga takaddun aiki da yawa tare da shimfidu daban-daban amma alamun bayanai iri ɗaya.

Muhimmin! Wannan hanya tana da alaƙa da yawa tare da samuwar tebur pivot. Koyaya, zaku iya sake tsara nau'ikan a cikin PivotTable. 

• Hakanan akwai hanya ta uku don haɗa bayanai - wannan shine ƙarfafawa ta amfani da dabaru. Gaskiya ne, da wuya a yi amfani da shi a aikace, saboda gaskiyar cewa yana ɗaukar lokaci mai yawa daga mai amfani.

Umurnin mataki-mataki don aiwatar da haɗin gwiwa a cikin Excel

Na gaba, za mu yi la'akari da hanya mafi sauƙi da sauri don ƙarfafawa.

Don haka, yadda ake haɗa teburi da yawa:

1. Da farko kana buƙatar ƙirƙirar sabon takarda, bayan haka software za ta ƙara ta kai tsaye a gefen dama. Idan ya cancanta, zaku iya ja takardar zuwa wani wuri (misali, zuwa ƙarshen lissafin) ta amfani da maɓallin linzamin kwamfuta na hagu.
2. Takardun da aka ƙara, tsaya a cikin tantanin halitta wanda za ku yi aiki da shi. Sa'an nan zuwa shafin "Data", nemo sashin "Aiki tare da bayanai", danna abin da ake kira "Consolidation".
3. Wani ƙaramin taga saituna zai bayyana akan mai duba.
4. Na gaba, kuna buƙatar zaɓar aikin da ya dace don haɗa bayanan.
5. Bayan zaɓar wani aiki, je zuwa filin "Haɗi" ta danna ciki. Anan zaka buƙaci zaɓar kewayon sel ɗaya bayan ɗaya. Don yin wannan, fara canzawa zuwa takarda tare da farantin farko.
6. Sannan zaɓi farantin tare da kai. Tabbatar cewa an yi komai daidai, sannan danna alamar "Ƙara". Af, zaku iya sabunta / canza daidaitawa da kanku ta amfani da madannai, amma wannan bai dace ba.
7. Don zaɓar kewayon sabon takarda, fara buɗe shi a cikin Excel. Bayan haka, fara tsarin haɗawa a cikin littafin farko kuma canza zuwa na biyu, zaɓi takardar da ta dace a ciki, sannan zaɓi wani yanki na sel.
8. A sakamakon haka, za a kafa shigarwar farko a cikin "List of Ranges".
9. Koma zuwa filin "Haɗi", cire duk bayanan da ya ƙunshi, sa'an nan kuma ƙara coordinates na sauran faranti zuwa jerin jeri.
10. Duba akwatunan da ke kusa da ayyuka masu zuwa: "Takamaiman Layi na Sama", "Dabi'un Rukunin Hagu", "Ƙirƙirar Haɗa zuwa Bayanan Bayanai".
11. Sannan danna "Ok".
12. Excel zai aiwatar da hanya kuma ya ƙirƙiri sabon takarda bisa ga sigogin da aka saita da ayyukan da aka zaɓa.

A cikin misali, an zaɓi haɗin kai, don haka an haɗa abin da aka fitar don taimakawa nuna/ɓoye daki-daki.

Ƙarin bayani game da amfani da jeri, ƙarawa da cire hanyoyin haɗi

• Don amfani da sabon kewayon don ƙarfafa bayanai, kuna buƙatar zaɓar zaɓin “Consolidate”, danna filin “Haɗi” kuma zaɓi kewayon ko saka hanyar haɗi. Bayan danna maɓallin "Ƙara", hanyar haɗin za ta bayyana a cikin jerin jeri.
• Don cire hanyar haɗi, zaɓi shi kuma danna "Cire".
• Don canza hanyar haɗin, zaɓi shi a cikin jerin jeri. Zai bayyana a cikin filin "Haɗi", inda za'a iya sabunta shi. Bayan da aka yi magudi, danna kan "Add" button. Sannan cire tsohon sigar hanyar haɗin da aka gyara.

Ƙarfafa bayanai yana taimakawa wajen haɗa mahimman bayanai waɗanda ke samuwa ba kawai a cikin tebur da zanen gado ba, har ma a cikin wasu fayiloli (littattafai). Hanyar haɗuwa ba ta ɗaukar lokaci mai yawa kuma yana da sauƙi don fara amfani da umarnin mataki-mataki.