Alt+DP C N I N (選範圍) Enter Enter
- Alt+D P 開啟舊的 pivote table wizard
- 選「多重彙總資料範圍」 -> 下一步
- 「我會自行建立分頁欄位」 -> 下一步
- 選擇 Table 範圍 -> 下一步 -> 完成
- 集中做完 unpivot 的資料
| /* | |
| Go on your labels page (https://github.com/user/repo/labels) | |
| Edit the following label array | |
| or | |
| Use this snippet to export github labels (https://gist.github.com/MoOx/93c2853fee760f42d97f) | |
| and replace it | |
| Paste this script in your console | |
| Press Enter!! |
| const path = require('path') | |
| const fs = require('fs') | |
| function walkDirSync (dir) { | |
| return fs.readdirSync(dir).reduce((filePaths, fileName) => { | |
| const filePath = path.join(dir, fileName) | |
| if (fs.statSync(filePath).isDirectory()) { | |
| return filePaths.concat(walkDirSync(filePath)) | |
| } |
| import memoize from 'lodash/memoize' | |
| function isNil (value) { | |
| return value === undefined || value === null | |
| } | |
| function sallowCopy (obj) { | |
| return Array.isArray(obj) ? [...obj] : { ...obj } | |
| } | |
| function toUpdateFunc (input) { |
| /* | |
| * 第 1 碼為 / | |
| * 其餘 7 碼為 0-9 A-Z . - + | |
| */ | |
| module.exports = (value) => { | |
| // - 需放最後,不然要會跟 0-9 的 - 混淆 | |
| const patt = /^\/[0-9A-Z.+-]{7}$/ | |
| if (patt.test(value)) return null |