Google Apps script to create all permutations from a table
- Create Google Sheet file
- Create a sheet with the label "INPUT"
- Per each column, starting from cell A1, input the list of elements to use in the permutation
- Go to: Tools -> Script Editor
- Copy and paste the script from crreate_all_permutations.gs into your Google Sheet file
- Run the function printPermutations()
- A new sheet with the label "OUTPUT" will be created with the list of permutations
There is a sample Google Sheet set up here with the INPUT and OUTPUT sheets: https://docs.google.com/spreadsheets/d/178RkmNxGvOrwtc3vWlnp3I7-MHNYQ42wEe0ezdYNhtE/edit#gid=1795575651