Gurus
In respect of my post for a Power Query solution https://www.ozgrid.com/forum/forum/he…amically-spaced
If I fail to receive any solution I may have to resort to VBA. However, although I know a bit of VBA this is beyond my skillset.
I have attached a workbook example with an Equipment List. The names of the equipment in Col A "Equipment Description" can be on 1 row, 2 rows or even more (this is dynamic). Is there a VBA solution to combine whatever cells are required to formulate them into Col B "Concatenated Equipment Description".
Any solution would be gratefully received.
Best
Paul