Categories

How I Dynamically Transform Column Names With Power Query

Published: 06 January 2024
on channel: Alejandra Horvath
1,967
80

Hello everyone!

Today I want to show you how to dynamically transform column names with Power Query.

In this example, we will split column names by the transition between lowercase and uppercase letters.

Hope you will find it useful. 😉

Remember to subscribe and share. 👍

Working files available here:
https://drive.google.com/drive/folder...

Thanks for watching 😊

#PowerQuery #MSExcel #DynamicTransformation #SplitText #SplitByTransition #PowerQueryGirl #AlejandraHorvath #Empowered2XL #TimeSavingTips #AutomateYourWork

play_arrow
125
11

Красная Машина Мультик| МУЛЬТИК СЕРИЯ № 2

Красная Машина Мультик| МУЛЬТИК СЕРИЯ № 2
play_arrow
2
like

Darryl gameplay in Brawl Stars! 🚀🔥😎

Darryl gameplay in Brawl Stars! 🚀🔥😎
play_arrow
6,079
78

დონ გურამიი🤣

დონ გურამიი🤣
play_arrow
2
1

време истеекло

време истеекло
play_arrow
39,235
512

Anak Dari Suami Berubah Sikap Kepada Ibu Tirinya - Ustadz Dr Syafiq Riza Basalamah MA

Anak Dari Suami Berubah Sikap Kepada Ibu Tirinya - Ustadz Dr Syafiq Riza Basalamah MA
play_arrow
54,356
638

Samsung Galaxy A70 - все возможности

Samsung Galaxy A70 - все возможности
play_arrow
17,342
87

Samsung DVD-K250 - DVD-караоке система - демонстрация работы и внутреннее устройство .

Samsung DVD-K250 - DVD-караоке система - демонстрация работы и внутреннее устройство .
play_arrow
13
1

Lost Wheels Locations in Saints Row

Lost Wheels Locations in Saints Row
Related
play_arrow
Running Totals - Power Query

Running Totals - Power Query
play_arrow
Table Schema can help you to select columns to keep (or remove)

Table Schema can help you to select columns to keep (or remove)
play_arrow
Dynamically Remove Empty Columns in Power Query

Dynamically Remove Empty Columns in Power Query
play_arrow
Double Headers - Power Query

Double Headers - Power Query
play_arrow
How I use the =DROP( ) function in Excel! - MS365

How I use the =DROP( ) function in Excel! - MS365
play_arrow
AGGREGATE - This Excel Function is a Real Treasure!

AGGREGATE - This Excel Function is a Real Treasure!
play_arrow
For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables

For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables
play_arrow
Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!

Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!
play_arrow
#Flashfill #AlejandraHorvath #Empowered2XL #Tutorial #MSExcel

#Flashfill #AlejandraHorvath #Empowered2XL #Tutorial #MSExcel
play_arrow
Filter With Wildcard #excel #tutorial

Filter With Wildcard #excel #tutorial
play_arrow
You Can Filter Several Columns At Once in Power Query!

You Can Filter Several Columns At Once in Power Query!
play_arrow
Are you creating the query in the same workbook? Do it fast and efficiently!

Are you creating the query in the same workbook? Do it fast and efficiently!
play_arrow
How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?

How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?
play_arrow
How to be the hero at work with Power Query & Power Pivot

How to be the hero at work with Power Query & Power Pivot
play_arrow
Optimize Table.SelectRows for better results! #PowerQuery

Optimize Table.SelectRows for better results! #PowerQuery
play_arrow
Convert Text To Date And Group By Quarters - Power Query

Convert Text To Date And Group By Quarters - Power Query
play_arrow
How To Start Working With Pivot Tables In Excel

How To Start Working With Pivot Tables In Excel
play_arrow
M - Lists Overview

M - Lists Overview
play_arrow
Simple and easy transformations for a better analysis - Power Query

Simple and easy transformations for a better analysis - Power Query
play_arrow
How I Dynamically Transform Column Names With Power Query

How I Dynamically Transform Column Names With Power Query
play_arrow
How I Replace Special Characters In a Text

How I Replace Special Characters In a Text
play_arrow
Table.TransformRows or Table.TransformColumns

Table.TransformRows or Table.TransformColumns
play_arrow
Replace Multiple Values With Power Query - Short Version

Replace Multiple Values With Power Query - Short Version
play_arrow
WRAPROWS & WRAPCOLS -You Will Love Them!!!

WRAPROWS & WRAPCOLS -You Will Love Them!!!