Skip to main content

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

The images aren't displaying


The images aren't displaying

Apologies about that. It should be fixed now.


Reply