Hi,
I have a spreadsheet with 6000 duplicated addresses. On the sheet column U is work to be carried out: so 3 duplicated addresses will say in column U (works to be carried out) Boiler on the row below will be kitchen and the next bathroom.
I need to take that information from the 3 rows...