Forum Discussion
Transform several rows into one muli-line cell
I have to work on a selection of about 4,000 song titles from about 250 albums. How do I automatically transform this: into this: I'm in my 70s, and never dared to mess with VBA -- but...
JanPlett , there are elegant, dynamic (auto-scalable) and robust ways by using newer techniques / advanced formulas already described. Or else, one can go step by step using helper columns. This technique uses smaller formulas one at a time. An example file is attached.