Skip to content

Instantly share code, notes, and snippets.

@Isaddo

Isaddo/UnpivotWithExcel.mkd

Created January 24, 2017 12:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Isaddo/a76d34e24d4ccb599b99b02e275e96e1 to your computer and use it in GitHub Desktop.
Save Isaddo/a76d34e24d4ccb599b99b02e275e96e1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
UnpivotWithExcel.mkd

Unpivot With Excel

Alt+DP C N I N (選範圍) Enter Enter

  1. Alt+D P 開啟舊的 pivote table wizard
  2. 選「多重彙總資料範圍」 -> 下一步
  3. 「我會自行建立分頁欄位」 -> 下一步
  4. 選擇 Table 範圍 -> 下一步 -> 完成
  5. 集中做完 unpivot 的資料
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment