This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
First post here, so hopefully I explain myself well enough!
I have a data set of different records with their associated addresses in the format below, all in one field. Each record has a blank row in between. I'm guessing I need to use the cross tab tool in some way, but wasn't sure of how to set up the parameters for it. I've looked elsewhere to see if anyone else has had this issue and haven't had any luck.
I'm hoping to reformat these records using that blank row as a delimiter to show: