looking for ideas or soulutions to transpose addresses

[JOECONCORDONTARIO]

I have an excell book with about 8000 rows.

Its an address book that i want to oganise so that i can filter etc.

Right basically like the below picture,. Howevre not all entries are the same amount of rows. some are 10 rows in length some are less due not having kids, or no emails, or no cell phones etc etc



is there there a way to automatically sort all data.

 

[BSALV]

is "Home: ...." a line in all records ?
If so, that can be used to reference for that whole block.
A solution for 2021 is easy, or should it also work in 2016 ?

 

[JOECONCORDONTARIO]

no Home is not in all records.

Basically, it has "show all info" at the top of each record, and if the record has 9-10 rows ( ie address, phone, etc etc) it lists all lines. If its doesnt its leaves the missing info out so some records will have 3-4 rows

 

[Fluff]

@JOECONCORDONTARIO I have removed your image as it contained personal data.
In future do not post other peoples personal data.
Thanks

 

[JOECONCORDONTARIO]

Please see updated image with clealry subsistuted date marked as test

 

[BSALV]

it 'll be a VBA-solution, as the data isn't consistent.
Home isn't there in every record, sometimes you have an emailaddress before the homeaddress etc.

Can i assume that there is a cohesive block of 5-6 rows and some separate rows for every record.
Can you post a number of different examples/situations with the XL2BB-tool (or a link)