Bari mu ce muna da fayil ɗin Excel tare da tebur masu wayo da yawa:
Idan kun ɗora waɗannan allunan cikin Query Query a daidaitaccen hanya ta amfani da umarnin Bayanai - Sami bayanai - Daga fayil - Daga littafi (Bayanai - Samun Bayanai - Daga fayil - Daga Littafin Aiki), sai mu samu wani abu kamar haka:
Hoton, ina tsammanin, sananne ne ga yawancin masu amfani da Query Query. Ana iya ganin teburi iri ɗaya bayan haɗa tambayoyin (a la VLOOKUP), haɗawa (umurni) Rukuni ta tab Sake Kama), shigo da duk fayiloli daga babban fayil da aka bayar, da sauransu.
Mataki mai ma'ana na gaba a cikin wannan yanayin shine yawanci don faɗaɗa duk teburin gida lokaci ɗaya - ta amfani da maɓallin tare da kibiyoyi biyu a cikin taken shafi. data:
A sakamakon haka, muna samun taro na duk layuka daga duk tebur zuwa gaba ɗaya. Komai yana da kyau, mai sauƙi kuma bayyananne.
Yanzu yi tunanin cewa an ƙara sabon ginshiƙi (Rangwame) a cikin tebur ɗin tushe da/ko ɗayan waɗanda ake dasu (Birnin) an share su:
Sa'an nan kuma buƙatarmu bayan sabuntawar za ta dawo da hoto mai kyau - rangwame bai bayyana ba, kuma ginshiƙi na birni ya zama fanko, amma bai ɓace ba:
Kuma yana da sauƙi don ganin dalilin da ya sa - a cikin madaidaicin ma'anar za ku iya gani a fili cewa sunayen ginshiƙan da aka faɗaɗa suna da hardcoded a cikin muhawarar aikin. Teburi.Expand TeburShafin kamar yadda jeri a cikin maƙallan lanƙwasa.
Samun kewaye wannan matsala yana da sauƙi. Da farko, bari mu sami sunayen ginshiƙi daga kan kowane (misali, na farko) tebur ta amfani da aikin Tebur. Sunayen Rumbun. Zai yi kama da:
Nan:
- #"An cire wasu ginshiƙai" - sunan mataki na baya, inda muke ɗaukar bayanai daga
- 0 {} - adadin teburin da muke ciro taken (ƙidaya daga sifili, watau 0 shine tebur na farko)
- [Bayanai] - sunan ginshiƙi a cikin mataki na baya, inda ɗakunan da aka fadada suke
Ya rage don musanya ginin da aka samu a mashaya dabara cikin aikin Teburi.Expand TeburShafin a mataki na faɗaɗa allunan maimakon lambobi masu ƙarfi. Ya kamata duk yayi kama da haka a ƙarshe:
Shi ke nan. Kuma ba za a ƙara samun ƙarin matsaloli tare da faɗaɗa tebura na gida ba lokacin da bayanan tushen ya canza.
- Gina allunan tsari da yawa daga takarda ɗaya a cikin Query Query
- Gina teburi tare da kanun labarai daban-daban daga fayilolin Excel da yawa
- Ana tattara bayanai daga dukkan zanen gado na littafin cikin tebur guda