Generate a SKU based on columns of data

Hi Experts!

I am trying to generate a listing of SKU's (probably thousands) based on an excel spreadsheet with a series of data in columns.



Capture.JPG


I would like to auto generate SKU's similar to the following:

SKU

TANKRDT00000M100
TANKRDT00000M1SM
TANKRDT00000M1MD
TANKRDT00000M1LG
TANKRDT00000M1XL
TANKRDT00000W100
:
:
:
TANKVLT0VLT0C1XL

Notice that I start at column 1 item 0, column 2 item 0,column 3 item 0, column 4 item 0, column 5 item 0, column 6 item 0, column 7 item 0
and then inclement column 7 to item 1 and the next SKU is column 7 item 2...until the last item in column 7 then I reset column 7 back to item 0
and inclrement column 6 to item 1...and so on until i go through every permutation.

Please can anyone help with the formul