Friday, June 7, 2024

10 awesome Power Query tricks you NEED to know! | Excel Off The Grid


0:00 Introduction
0:15 Tip 1: Using line feed 1:41 Tip 2: Rename column by position 2:57 Tip 3: Rename column by position in a nested table 5:09 Tip 4: Rename column based on a list in a nested table 7:00 Tip 5: Expand columns without using column names 8:28 Tip 6: Combine text in a cell with group by 10:17 Tip 7: Group by and ignore case 11:29 Tip 8: Get cell by position 13:01 Tip 9: Multi-step custom column 14:44 Tip 10: Declare column data type when adding a column 15:29 Wrap up

No comments:

Post a Comment