Excel:

Trick to Divide a Number by 100 - Excel:

Formula in B2 cell,

=A2:A9%

Power Query:

Advanced Filter using Table.FindText - Power Query:

Our goal is to apply filter and select rows which contains '*'.

let

Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

Result = Table.FindText(Source,"*")

in

Result

Python in Excel:

Flatten a List - Python in Excel:

Input data contains nested list structure.

L = [ [112,234], [1011,1210], [3216,5678] ]

Our goal is to make it a single list.

Method-1:

sum(L, [])

Method-2:

[x for i in L for x in i]