🌻Transformation

Things to consider

First record is header, then use column names to specify the target columns

First record is not header, then use the column indexes to specify the target columns

Data Transformation

• Average by group

• Change text casing

• Clean data

• Combine columns

• Combine tables

• Compare dates

• Convert array of objects to array of arrays

• Count by group

• Extract text from column

• Fill in blanks

• Filter rows

• Find and replace

• Find maximum by group

• Find min/max per row

• Find minimum by group

• Flatten rows

• Format dates

• Format numbers

• Insert date & time column

• Insert growth rate column

• Insert if/else column

• Insert if/else blank column

• Insert math column

• Insert row numbers

• Insert rows

• Insert running total column

• Insert text column

• Limit rows

• Merge duplicate rows

• Pivot columns

• Remove duplicate rows

• Rename columns

• Select columns

• Reorder columns

• Sort rows

• Split column

• Stack tables

• Sum by Group

• Unpivot columns

• Use regex

Average by group

Average by group