Dear Masters of Excel,
Expanding on an old thread - http://www.mrexcel.com/forum/excel-questions/356861-concatenate-maybe-countif-but-how.html - I could do with a little help.
Mr Excel offers the macro;
Sub Rearrange()
Dim lr AsLong, r AsLong
Application.ScreenUpdating = False
lr =...