Hi brilliant forum people
I'm looking for ideas on how to solve a GV output problem.
I have 6 columns from I/C that I am exporting to .cfv to import into my website.
THese columns represent an item's "Size","Colour" or "Weight" (e.g. XL & Black for Jacket)
Some items will only be listed with colour or weight, some might use 2 variants.
The websites requirements are that the columns are aligned to the leftmost column.

If I concatenate the 6 columns together is there a way to then split back out to first word, second word, third word, etc?
I can do this in excel and google sheets but not sure how to extract the nth word in Gridview.

e.g. The outputted columns look like this.
SKU #___| Size_|Size Value | Colour | Colour Value| Weight | Weight Value |
item 1324 |_____|_________| Colour | Black______|_______|____________|
item 1325 |_____|_________| Colour | Red_______|_______|____________|
item 1326 |_____|_________| Colour | Green______|_______|____________|

I need to have calculated columns look like this.
SKU #___| opt#1 _| opt1 Value__| opt#2__| opt#2 Value_| opt#3__| opt#3 Value__|
item 1324 | colour_| Black______|_______|___________|_______|____________|
item 1325 | colour_| Red_______|_______|___________|_______|____________|
item 1326 | colour_| Green_____|_______|___________|_______|____________|

Is there an easier way to re-align these values to the leftmost columns? Any Ideas?

Thank you in advance.
Adrian