Code Snippets

Excel

How To Transpose Every N Rows of Data into Multiple Columns in Excel

=INDEX($A:$A,ROW(A1)*2-2+COLUMN(A1))

Fill blank cells with last non-empty cell

=XLOOKUP(TRUE,$A$1:A1<>"",$A$1:A1,,,-1)

Docker

Allow mouse to scroll

setw -g mouse on

Unix

List bigger folders

du -ha /var/ 2>/dev/null | sort -n -r | grep -v "/var/log/" | head -n 20