Question

Pivoting in Groups

  • 23 January 2019
  • 2 replies
  • 2 views

Badge

I have an old unconventional excel worksheets which need to be restructured. See below:

 

The first column are field names and every subsequent column is a route number. Ideally, I'd like to transform it to the following:

 

Any recommendations on how to pivot every n rows per column??


2 replies

Userlevel 1
Badge +10

The images aren't displaying

Badge

The images aren't displaying

Apologies about that. It should be fixed now.

Reply