Please see attached spreadsheet
I have thousands of similar entries in a spreadsheet and need a macro that I can use to convert as described in the worksheet and also for future spreadsheets.
It is a transpose type function but I need all Names in the one cell and all Addresses in the one cell for each "item".
There is always an Amount in the first line of each "item".
Really appreciate some help.
Bookmarks