你喜歡哪一種呢!? 📝方法1-函數法(限2021以上) 💡=TOCOL(範圍) ▮把範圍的資料變成一欄 💡=INDEX(姓名,INT(SEQUENCE(27,,0)/3) 1) ▮SEQUENCE(27,,0)：產生 0～26 ▮÷3 → INT：每 3 個變成同一組（0,0,0,1,1,1…） ▮ 1：變成 1～9 ▮INDEX：從 B3:B11 取人名，每人重複 3 次 📝方法2-Power Query ▮資料 > 從表格範圍(進入Power Query) ▮選取要整理的資料行(按住Shift選取) ▮轉換 > 取消資料行樞紐 ▮關閉並載入(匯出資料到EXCEL) ----------------------------- 如果你對 Power Query 有興趣 我有製作一堂非常適合初學者的線上課程 《一小時 Power Query 速成班》 ▮即使你是第一次接觸 Excel ▮不會寫函數（而且也完全不需要寫） ▮也能快速學會用Excel自動化處理重複性工作 課程頁面裡有提供試閱影片 你可以先看看內容是否符合你的需求👇 https://s-school16870.tea
1:00
你喜歡哪一種呢!? 📝方法1-函數法(限2021以上) 💡=TOCOL(範圍) ▮把範圍 …
1.2K views3 weeks ago
Facebook效率職人Efficiency Person
Political Power | Full South Hindi Dubbed Comedy & Action Movie | Pramod Panju, Milana Nagaraj
2:24:26
Political Power | Full South Hindi Dubbed Comedy & Action Movie | …
5.6K views1 month ago
YouTubeHOUSEFULL CINEMA
数据匹配查询 表单比对不在用公式 点点数据表就能搞定 Powerquery 实战应用 数据查询vlookup 函数excel 进阶教学excel教學 零基础excel教學 函数
19:08
数据匹配查询 表单比对不在用公式 点点数据表就能搞定 Powerquery …
281 views1 month ago
YouTubeJill Liu
power rangers legacy good vs evil how sill win the fight #shorts
1:20
power rangers legacy good vs evil how sill win the fight #shorts
192 views5 days ago
YouTubeChaggn Gamer
🔥 Wrong Tool Alert: Search Query vs Custom Search in Copilot Studio! #shorts
0:29
🔥 Wrong Tool Alert: Search Query vs Custom Search in Copilot Studio! …
18 views1 week ago
YouTubeMicrosoft Techy Tips
Power Query Advanced Replacer: Replace Whole Cells with Null Using Custom Functions
4:45
Power Query Advanced Replacer: Replace Whole Cells with Null Usi…
1 week ago
YouTubeOmidBI
Skillwave Training on Instagram: "When importing data in #Excel or #PowerBI via #PowerQuery, it's a good idea to set the data types of your columns. But with wide tables, this can take a lot of time as you set each column and then have to wait for Power Query to catch up. 😭 In this episode of Monkey Shorts, Ken Puls shows a tip to quickly set ALL data types, so that you only have to fix the ones that Power Query sets differently than you'd like. 🙌 #DataPreparation #DataAnalysisTools #DataAnaly
2:34
Skillwave Training on Instagram: "When importing data in #Excel o…
113 views1 week ago
Instagramskillwavetraining
5:28
Count of Unique Values (DistinctCount) in Power BI Throu…
Feb 27, 2020
radacad.com
用PowerQuery解决两列数据查找不同、生成差异列问题
1.4K viewsAug 9, 2022
bilibili我有一头小驴驴Vlog
9:51
Dynamically expand table column in Power Query (advanced)
11K viewsFeb 11, 2021
YouTubeExceed Learning
6:10
2014 Honda 420 electronic power steering not working, reset instruc…
67.9K viewsFeb 23, 2018
YouTubejoshlindhorst
5:44
Adding leading zeros using Power Query ( Excel or Power BI )
17.7K viewsApr 9, 2021
YouTubeAccess Analytic
6:43
Three Ways to add Leading Zeros to Numbers in Power Query
24.9K viewsFeb 24, 2021
YouTubeBI Gorilla
3:59
三分鐘學會40《Excel 2016 使用POWER QUERY進行不規則資料整 …
39.1K viewsAug 24, 2019
YouTube林大叔
34:20
Problemas Mais Comuns no Power Query e Como Resolve-los (Pass…
95.9K viewsDec 9, 2020
YouTubeHashtag Treinamentos
8:41
Power Query M函数 67 记录的操作、循环、集合
260 viewsMar 16, 2021
zhihu.com孙兴华zz
4:05
PHILIPS SFL2143/56 Torch || Rock Light RL-M35 Metal Torch || Best L…
589 views1 month ago
YouTubeFaizu Ki Tips
7:46
PowerQuery: Fix MonthYear Date Conversion
6.4K viewsJan 7, 2020
YouTubeYour Excel Solution
6:42
【Excel 高效神器：Power Query】合併工作表
51.3K viewsJun 26, 2022
YouTube職場MVP
3:00
Bring MULTIPLE Google Sheets Into Power BI EASILY!
11.6K views1 month ago
YouTubePragmatic Works
12:02
Power Query入門介紹：自動合併工作表
12.7K viewsDec 5, 2023
YouTubeFanlovexcel
9:56
Ignoring Case Sensitivity in Power Query
15.3K viewsMay 2, 2022
YouTubeGoodly
0:08
5 Excel Tricks to Instantly Level Up
1.8K views1 month ago
YouTubeCoursera
3:51
七個常見的Power Query自動化應用情境
160 views3 weeks ago
YouTube效率職人 Efficiency Person
6:10
Mastering Power Query: Conditionally Replacing Values
5.5K viewsOct 24, 2023
YouTubeLet's Power BI
9:57
Return Previous Row Value in Power query
35.3K viewsMar 17, 2021
YouTubeBI Gorilla
9:12
Power Query移除重複項目，我要最後一筆
13.9K viewsNov 1, 2021
YouTube贊贊小屋
3:59
How to LIMIT ROWS Dynamically in Power Query | Power BI
26.1K viewsMay 26, 2023
YouTubeBI Tricks
4:17
Return Rows with Maximum Value in Power Query
20.5K viewsJun 22, 2022
YouTubeBI Gorilla
4:24
How to Replace Column Values in Power Query (Excel & Power BI)
9.2K viewsMar 8, 2023
YouTubeGo Analytics
See more videos
Static thumbnail place holder