Forum Discussion
Splitting a table taking one portion and putting it under the other via LET - file format changed
PeterBartholomew1 - thanks for taking time to look at. I am good - finally - so many people happy now - but me more than any of them. I need to go back to my solution architect role.....
NotSoFastEddie Not sure if you saw my reply to your last inquiry found here https://techcommunity.microsoft.com/t5/excel/take-a-series-of-rows-and-break-each-row-into-multiple-rows/m-p/4147130#M229877 where I used the REDUCE function to iterate through the 3 languages, as opposed to the TOCOL / IF / SEQUENCE method, in order to return different columns for "fr_CA".
If you didn't like that method, please try the newly attached file below, where only the 2 English languages {"en_CA";"en"} are used to repeat the English columns, and the French columns are then stacked below it...
NotSoFastEddie Check it again and look closely. I just redownloaded both files (your original and my version) and they are not the same. I made the changes to the formula directly in cell A2, so the "current state" results match the "desired state" that you hard-keyed below. Scroll to the right and you'll see the results only go to column U in my file, whereas the original file goes all the way to column AM. Compare the files side-by-side and the differences will be obvious.
djclements Thanks again. Merged it into the big spreadsheet and it works beautifully. At least I was on the right path with what I was attempting, just getting some weird results.
That wraps it up for this spreadsheet. Want to thank you for all your help - could not have done it without you.
