Split up addresses

[NewbieJono]

i have a list of address in excel in this format

Address line 1

Address line 2

Town

Sa91pd

Address line 1

Address line 2

Town

Sa91pd

Address line 1

Address line 2

Town

postcode

the list is all in one coloumn and has multiple address. is there a method to have each address on one line with mutiple coloumns?

[CNENFRNL]

@NewbieJono , simple enough as every complete address consists of 4 rows,

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckxJKUotLlbIycxLVTBUitVBEzICC4Xkl+eBGcGJloYFKZjKaKmzIL+4JDk/JVUpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Address = _t]),
    Custom1 = Table.FromRows(List.Split(Source[Address],4))
in
    Custom1

[NewbieJono]

sorry, to make this more complaicated some address have 5 rows!

the postcode seem to be consitantly in captials if this is any help

[v-kelly-msft]

Hi @NewbieJono ，

Could you pls attach your expected output?It's a bit confused about your requirement.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!