Pyclip.ru
  • English English
  • Русский язык Русский
Categories
  • Auto
  • Music
  • Sport
  • Technology
  • Animals
  • Humor
  • Movies
  • Games
  • Hobby
  • Education
  • Blogs

  • Searching now
  • Watching now
  • TOP queries
  • About us
Categories
  • Auto
  • Music
  • Sport
  • Technology
  • Animals
  • Humor
  • Movies
  • Games
  • Hobby
  • Education
  • Blogs

  • Searching now
  • Watching now
  • TOP queries
  • About us
  1. Main page
  2. WesleySon

27.1 - Split a table into tables with 50 rows (Power Query)

Published: 14 June 2023
on channel: WesleySon
1,974
13

How to split one big table into many smaller tables, with each mini-table being on its own sheet. In this case I want my table to be split into 50-row portion.
This can be relevant to more easily divide work among multiple coworkers working in the same workbook.

The VBA solution got too big and I'm splitting the video into two videos.


play_arrow
416
9

Программирование в Windows. Базовая программа Windows Часть 1

Программирование в Windows. Базовая программа Windows Часть 1

play_arrow
64
4

MP9 M.O.A.B!

MP9 M.O.A.B!

play_arrow
178
10

1 Эволюция Валентины Castle Clash (Битва Замков)

1 Эволюция Валентины Castle Clash (Битва Замков)

play_arrow
201
10

IS IT TOO LATE TO GET INTO GENSHIN IMPACT? EVERYTHING YOU NEED TO KNOW!

IS IT TOO LATE TO GET INTO GENSHIN IMPACT? EVERYTHING YOU NEED TO KNOW!

play_arrow
185
3

Компьютерное моделирование в астрономии

Компьютерное моделирование в астрономии

play_arrow
1,557,199
19K

ASMR MUKBANG DOMINO’S EXTRA CHEESY PEPPERONI PIZZA, CREAMY PASTA, CHEESY BREAD | WITH CHEESE & RANCH

ASMR MUKBANG DOMINO’S EXTRA CHEESY PEPPERONI PIZZA, CREAMY PASTA, CHEESY BREAD | WITH CHEESE & RANCH

play_arrow
7,971,912
105K

اخيرا الفديو المطلوب☝️بشده جوله في بيت حماتي 🏘بالشكل النهائي بعد ما اتشطب ده اللي كان لازم اعملو👌

اخيرا الفديو المطلوب☝️بشده جوله في بيت حماتي 🏘بالشكل النهائي بعد ما اتشطب ده اللي كان لازم اعملو👌

play_arrow
4,836
101

Manche Leute sind's nicht wert - Helene Brockhorst

Manche Leute sind's nicht wert - Helene Brockhorst

Related
play_arrow
97 - List Generate

97 - List Generate

play_arrow
86 - Split columns, varying number of columns (Power Query)

86 - Split columns, varying number of columns (Power Query)

play_arrow
83 - Days between, remove weekends (Power Query)

83 - Days between, remove weekends (Power Query)

play_arrow
81- Aggregate, to e.g. find the next birthday (Excel)

81- Aggregate, to e.g. find the next birthday (Excel)

play_arrow
80 - Recursion in VBA (find the next valid day)

80 - Recursion in VBA (find the next valid day)

play_arrow
79.1 - Python, Weeks to years and months

79.1 - Python, Weeks to years and months

play_arrow
78 - Fixing spelling mistakes, Text Replace vs If (Power Query)

78 - Fixing spelling mistakes, Text Replace vs If (Power Query)

play_arrow
76 - As and Is (Power Query)

76 - As and Is (Power Query)

play_arrow
75 - Recursion in Power Query

75 - Recursion in Power Query

play_arrow
Oops, all ants

Oops, all ants

play_arrow
73 - Making an Excel sheet Very Hidden

73 - Making an Excel sheet Very Hidden

play_arrow
72 - Dynamically updating a title + changing y axis (Power BI)

72 - Dynamically updating a title + changing y axis (Power BI)

play_arrow
71 - Indirect

71 - Indirect

play_arrow
69 - Function scope in Power Query

69 - Function scope in Power Query

play_arrow
64.1 - Time to update a query, pure M

64.1 - Time to update a query, pure M

play_arrow
84 - Storing and accessing metadata, eg count rows of steps (Power Query)

84 - Storing and accessing metadata, eg count rows of steps (Power Query)

play_arrow
68 - Creating a cumulative sum column in Power Query

68 - Creating a cumulative sum column in Power Query

play_arrow
66 - Playing with lists in Power Query

66 - Playing with lists in Power Query

play_arrow
65 - \d{3} regex in Power Query

65 - \d{3} regex in Power Query

play_arrow
64 - Use VBA to update queries, and measure the time it took

64 - Use VBA to update queries, and measure the time it took

play_arrow
79 - Function to turn weeks into years and months (Excel, Excel 365 and VBA)

79 - Function to turn weeks into years and months (Excel, Excel 365 and VBA)

play_arrow
Factorio, a train stop with dynamic train limits

Factorio, a train stop with dynamic train limits

play_arrow
Factorio, having a train deposit to multiple stations

Factorio, having a train deposit to multiple stations

play_arrow
79 - Handling a weird data structure (blanks and transpose) (Power Query)

79 - Handling a weird data structure (blanks and transpose) (Power Query)

Pyclip.ru

Watch without registration the best video content in hd quality from any device at home, in the car, on the plane, at work or on holiday!


  • Auto
  • Music
  • Sport
  • Technology
  • Animals
  • Humor
  • Movies
  • Games
  • Hobby
  • Education
  • Blogs
  • Searching now
  • Watching now
  • TOP queries
  • About us
  • Sitemap

[email protected]