50. Jak Podzielić Tekst w Kolumnie Za Pomocą Power Query W Układzie Kolumnowym i Wierszowym

In the video, I'll show you how to split text in a column where the internal Alt+Enter separator is used in the cells, which means that we have multiple rows stored within the same cell. Power QUERY will split text into individual columns (columnar layout) or rows (database layout), which is ideal for further work, such as in PivotTables. As always, when using POWER QUERY, the model will be dynamic, meaning it will respond to any changes in the source data. This is another video in the Split Text Using Excel series. I invite you to watch the next videos and check out the playlist:    • Podziel tekst za pomocą Excela   Video files: https://bit.ly/3jVyRhk Please contact me - I can help you with Excel or conduct individual or company training: Wojciech Wiśniewski tel. +48 600 839 522 email: [email protected]