I am hoping someone can help.  I am running out of time and well out of skill.

The attached spreadsheet is a subset of a much larger one.  Essentially, the LET statement is very cool (DJClement) and I have modified it to meet the distributed pattern of columns I need to gather.  

The current LET formula produces a rows of en_CA, en and fr_CA where the information is duplicated for each of the locale types in as one wide table.  I need to get the French columns underneath the equivalent English ones. 

The list takes from a source worksheet and generates the output in a new worksheet.  

I have tried a few different ways, but have only had limited success.

This is a pic of the current output and the desired state below).

​I am hoping someone can help.  I am running out of time and well out of skill.The attached spreadsheet is a subset of a much larger one.  Essentially, the LET statement is very cool (DJClement) and I have modified it to meet the distributed pattern of columns I need to gather.   The current LET formula produces a rows of en_CA, en and fr_CA where the information is duplicated for each of the locale types in as one wide table.  I need to get the French columns underneath the equivalent English ones. The list takes from a source worksheet and generates the output in a new worksheet.   I have tried a few different ways, but have only had limited success. This is a pic of the current output and the desired state below).   Read More

​