stack 2 columns (append). index function or power query? excel magic trick 1644.
Published 4 years ago • 18K plays • Length 6:47Download video MP4
Download video MP3
Similar videos
-
8:28
append multiple columns with excel dynamic spilled array formula. excel magic trick 1646.
-
5:10
append two number columns and sort. excel magic trick 1682.
-
24:51
excel magic trick 1326: conditionally format text modes: pivottable, array formula or power query?
-
9:24
append tables with excel formula: textjoin, filterxml, index & sequence functions. emt 1713
-
4:07
excel formulas, text to columns or power query to fix dates. excel magic trick 1790
-
2:52
index function to lookup column inside countifs function - excel magic trick 1574
-
16:31
exact & approximate match lookup formulas in power query. 4 amazing formulas. excel magic trick 1747
-
18:40
power query - avoid "helper queries" ( 10 cool tricks)
-
11:30
lookup manager name in column headers to create report: excel magic trick 1866
-
10:26
create index column by group in power query
-
11:46
excel magic trick 1356: lookup 3 items & return to single cell helper column or power query?
-
3:02
excel text to columns or split to rows: worksheet formula or power query? excel magic trick 1795
-
12:33
excel magic trick 1329: clean data then add w 2 criteria: sumifs or power query (get & transform)?
-
13:09
power query append / combine tables: 3 amazing methods. excel magic trick #1714.
-
6:57
column of records into table. power query. 2 methods. excel magic trick 1717
-
10:20
tocol, drop, expand array functions to unpivot data into proper table. excel magic trick 1785
-
1:00
excel pro trick: combine / merge / append / stack multiple columns into one with #excel power query
-
8:32
excel magic trick 757: two lookup values & 2 lookup columns? great formula index & match
-
1:09
[power query] transpose multiple columns into one column
-
0:45
merge or concatenate two columns in ms excel
-
6:15
excel magic trick 1386: power query to import & append large text file in power pivot data model