Transposing - Line Break Cell

[arupghoshal]

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 332"]
<tbody>[TR]
[TD="class: xl70, width: 332, align: left"]601, Khatau Condominium
J.M. Mehta Road
Nepean Sea Road
Mumbai 400006[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD="width: 228, align: left"]601, Khatau Condominium[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD="width: 228, align: left"]J.M. Mehta Road [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD="width: 228, align: left"]Nepean Sea Road [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD="width: 228, align: left"]Mumbai 400006[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD="class: xl64, width: 228, align: left"]Gold Croft, 3rd Floor
39, Bhulabhai Desai Road
Mumbai 400026[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD="class: xl66, width: 228, align: left"]B1-209, Ostwal Ornate
Jaisal Park
Bhayender (E)
Mumbai 401105 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hello All,

I am a newbie... first post

As you can see from the above table, I have a whole list of addresses which are typed into one cell with line breaks in them.

I want to transpose it into adjacent cells divided by these line breaks as I have tried to demonstrate above. currently, I am having to copy+paste them individually into sepearate columns in the same row.

If someone can help automate it, would be highly obliged.

Thanks and regards,
Arup

 

[arthurbr]

Select the column - Data - Text to columns -select " delimited" check the " Others" checkbox. In the box hit Ctrl+j and then Finish

 

[arupghoshal]

Select the column - Data - Text to columns -select " delimited" check the " Others" checkbox. In the box hit Ctrl+j and then Finish

Wow!

Thanks a ton. You saved me a ton of menial work.... Much appreciated.

Warm Regards,
Arup

 

[arthurbr]

You're welcome