Forum Discussion
Moving cell content from one column to rows based on an adjacent cell
Hello, I have a spreadsheet with two columns. Column 1 has text that is repeated as well as some terms that are not repeated. Column has text based on the text in column 1. I need a formula that ...
Savia So my version of Excel is an older version (Office 2013) that doesn't support the _xlfn function. However, I opened the file you sent me in the same Excel version, and the formula is working there. Any idea what's up with that? Everything else seems to work like a charm. I copied your formulas exactly and used the CSE command for the arrays.
Mary Jo
I only used the newer functions for making the lists of values - the main function is backwards-compatible so should be working fine. If you added more items later on then you'd need to update the labels as I describe but the rest should work fine 🙂