Selects specific columns from a table in Power Query.
Challenge No. 116: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, COLUMN), Google Sheets, Power Query (List.Alternate, Table.AlternateRows, Table.Column), Python, Python in Excel, and R.
Challenge No. 102: In the historical sales table, identify and extract the dates where the sales value on that date is greater than the sales on the previous date.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.SelectColumns), Python, Python in Excel, R, and VBA.
Challenge No. 79: In the question table, some columns are entirely blank.
Solved using:Excel (BYCOL, FILTER), Power Query (List.Transform, Table.Column, Table.ColumnNames), Python, Python in Excel, R, and VBA.
