@specialtalentz: #tanzaniantiktok🇹🇿 #kenyantiktok🇰🇪 #

90%GenZ-MEDIA
90%GenZ-MEDIA
Open In TikTok:
Region: TZ
Monday 09 November 2026 07:41:42 GMT
108554
3487
187
516

Music

Download

Comments

mamier.ansary
mamier ansary :
afu ameglow😅😅😅
2026-11-09 13:55:03
31
nteruka1andonly
NTERUKA dry cleaner 👕👖🥼👙 :
kipindi hichooooo
2026-11-09 12:35:12
15
trianna.collection
Trianna collection 👗👠👜 :
[Tears of joy][Tears of joy][Tears of joy]Seba
2026-11-09 18:28:29
0
asha.sadick4
Asha Sadick :
Nikikumbuka vijana wamtaani kwetu walivyokua wakigombania jina la seba nachoka mimi😳😳😳
2026-11-09 13:41:38
16
geraldbenjamin37
Rêãl hústleër🛠️💪 :
mbn kama vile merlin hayupo carmelot
2026-11-09 16:20:51
4
mr..dolphin44
MR. DOLPHIN🐬 :
hapo kuna mambo haya ✌️
2026-11-09 15:15:01
3
mamu.kipini55
mamu kipini 🦋 :
tesla haina elon musk😂
2026-11-09 17:38:57
1
doctor_tangi
Doctor Tangi 🏥🩺💉 :
[Innocent] dahaa sebaaaa !!!
2026-11-09 15:26:35
0
neina589
Neema🫦🦋🥰 :
Pombe sio yeye msikuze maneno kaaah
2026-11-09 15:46:33
5
user3838157806202
salma :
hahahahaha seba wetu mwendo ameumaliza
2026-11-09 18:22:27
1
tynest56
fine as wine :
Tuketoka mbali na bongo movie 😂😂
2026-11-09 18:04:02
0
akram1487
Akram14 :
😂😂😂 Ila kuna mambo haya vumiliki lazima ucheke tuu hapo kwa Affew moment
2026-11-09 16:17:14
3
asedijr
💯 asedi :
hheeere atnzaaa😁😁😁😳😳😳😳
2026-11-09 11:16:52
2
user63930982965
Leyla sadala :
nachoka mm
2026-11-09 10:21:50
2
narry.mussa
Narry offcial. 🦋🦋 :
Me nashindwa kuelewa
2026-11-09 10:22:51
2
kijugumaxter
kijugumaxter :
tumepoteza ubingwa
2026-11-09 15:00:42
1
ginah0891
ginah :
Alikuwaga muimba taarabu kwani😅
2026-11-09 14:43:29
1
kipaku57
BAD BOY 👑 👑 ❤️ :
Daa
2026-11-09 09:30:44
2
adellahid
Ade classic wear👖👕🥾👟 :
2026-11-09 16:36:05
0
user9594765025882
nasibu jr🇬🇧🇹🇿 :
seba😂😂
2026-11-09 11:16:14
1
jacklinemussa375
JACKLINE MUSSA :
jamn pombe. sio chai
2026-11-09 14:45:44
4
husnaatiktok
Mayrah's mom🥀🥀 :
watanifanya nikatafute movie yake alaf nimtazame vzur yeye tyu
2026-11-09 13:23:03
2
omary.mtete
King 🤴 omz :
kama uwanjan bc tuko pungufu
2026-11-09 11:00:01
1
ujamaa.tz
☘️UJAMAA TZ ☘️ :
sio seba huyo ni AI[Tears of joy]
2026-11-09 13:15:39
1
fadhilndola
Mr fadhili 🚛 :
Enzi hizooo
2026-11-09 10:58:31
0
To see more videos from user @specialtalentz, please go to the Tikwm homepage.

Other Videos

Lists in Excel often need to be reshaped depending on the task at hand. Sometimes you'll have a flat list, where each value appears in its own row without any grouping or hierarchy. If a value occurs multiple times, it will simply be repeated X number of times. On the other hand, an itemised list contains one instance of a unique value per row — but has one or more additional columns to house associated details. How do you convert one to another? 𝗙𝗟𝗔𝗧 𝗟𝗜𝗦𝗧 → 𝗜𝗧𝗘𝗠𝗜𝗦𝗘𝗗 𝗟𝗜𝗦𝗧 In the example, several cafe drinks appear in A3:A25 multiple times:
Lists in Excel often need to be reshaped depending on the task at hand. Sometimes you'll have a flat list, where each value appears in its own row without any grouping or hierarchy. If a value occurs multiple times, it will simply be repeated X number of times. On the other hand, an itemised list contains one instance of a unique value per row — but has one or more additional columns to house associated details. How do you convert one to another? 𝗙𝗟𝗔𝗧 𝗟𝗜𝗦𝗧 → 𝗜𝗧𝗘𝗠𝗜𝗦𝗘𝗗 𝗟𝗜𝗦𝗧 In the example, several cafe drinks appear in A3:A25 multiple times: "Cappuccino", "Espresso", "Hot chocolate", "Latte", and "Mocha". Thanks to Excel's GROUPBY function, it's pretty easy these days to convert them from a flat list to an itemised list. The formula in C3 is: = GROUPBY( A3:A25, A3:A25, COUNTA, , 0 ) This categorises each drink type and uses the built-in COUNTA function to count how many there are in each group. The presence of 0 in [total_depth] also prevents the 'Total' row from appearing in the result. 𝗜𝗧𝗘𝗠𝗜𝗦𝗘𝗗 𝗟𝗜𝗦𝗧 → 𝗙𝗟𝗔𝗧 𝗟𝗜𝗦𝗧 The example begins with the itemised list of drinks, which is composed of static values this time. The formula in D3 is: = TEXTSPLIT( CONCAT( REPT(A3:A7&"|",B3:B7) ), ,"|", TRUE ) REPT is used to repeat each drink in A3:A7 according to the quantity in B3:B7, with the vertical bar (|) acting as the separator. Combined with CONCAT, this forms one long string that TEXTSPLIT then divides into separate rows. TRUE removes the empty cell that would otherwise appear at the end. The result is a flat list with each item shown the correct number of times. #excel #microsoftexcel #exceltips #exceltricks

About