Skip to main content
Question

Pivoting in Groups

  • January 23, 2019
  • 2 replies
  • 12 views

Forum|alt.badge.img

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??

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3429 replies
  • January 23, 2019

The images aren't displaying


Forum|alt.badge.img
  • Author
  • 28 replies
  • January 23, 2019

The images aren't displaying

Apologies about that. It should be fixed now.