Extract Data From Grid To A List

Basically, I need to extract data from a grid/table (11 columns wide) and transpose it into a list for use in a pivot table. It like sort of reversing a pivot table to access the original data but I only need 5 of the columns repeated for each occurrence.

I have read many internet sources but they don't seems to fit my needs. Here is a solution from a similar question posted on StackOverflow entitled "How to “flatten” or “collapse” a 2D Excel table into 1D?"

The attached simplified mock-up explains what I am trying to do. I have colour coded the data to understand. The number of rows (10) will always be the same but the number of columns (Branches in this case) can extend for many columns.