#Renaming
Join me this Saturday for another Power Query session 🪄
Today, we explore 3 different solutions to rename columns, including List.Accumulate.
Hope you find it useful 😊
Files available here:
https://drive.google.com/drive/folder...
Note: I have rename the files with the correct date, from 2022Oct21 to 2022Oct22; the content was not changed.
During this session:
00:00 Intro
06:30 Overview of what we will achieve today
14:46 Start – Bring your file to the Power Query editor
16:46 First Solution – Transpose
19:43 Remove unwanted first rows dynamically
23:35 Transpose and split text from lowercase to uppercase
26:33 How to get the formula bar visible
27:57 Create a custom function with this solution
29:59 Invoke the custom function
33:16 Why I chose not to expand columns from nested tables
35:04 Inserting a column to the nested tables
42:10 Second Solution – Column names in a column, duplicate, transform and use as reference for Table.RenameColumns
43:15 Transform column names to a table, using Record.ToTable - Overview
47:25 Start the process by removing unwanted first rows dynamically
53:07 Get name of columns to dynamically merge
1:03:16 Convert the second solution process into a function
1:05:08 Invoke the custom function
1:13:12 Third Solution – Using List.Accumulate
1:34:15 Tip on how to make sure that all your queries will refresh when you click at “Refresh All”
1:36:45 Wrap up
During this session you can find more information on List.Accumulate here:
• List.Generate and List.Accumulate to ...
Hope you find this information useful.
Thanks for watching 😊
#MSExcel #PowerQuery #SaturdayWithPowerQuery