Hi All,
I have faced a big problem. I have huge data with name, address, email. I want to copy data between 2 email address to sheet2 & transpose.
For example:
Sheet 1:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Mr Karim[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]234, by lane[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]abc@gmail.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr rashed[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]015987456[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]365 by lane mc road[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]amik@yahoo.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr Sumon[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sumon@bd.net[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]khaled ali[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sumr road[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sumil@gmail.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2: Output
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Mr Karim[/TD]
[TD]234, by lane[/TD]
[TD]abc@gmail.com[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr rashed[/TD]
[TD]015987456[/TD]
[TD]365 by lane mc road[/TD]
[TD]amik@yahoo.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr Sumon[/TD]
[TD]sumon@bd.net[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]khaled ali[/TD]
[TD]sumr road[/TD]
[TD]sumil@gmail.com[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance
I have faced a big problem. I have huge data with name, address, email. I want to copy data between 2 email address to sheet2 & transpose.
For example:
Sheet 1:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Mr Karim[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]234, by lane[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]abc@gmail.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr rashed[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]015987456[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]365 by lane mc road[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]amik@yahoo.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr Sumon[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sumon@bd.net[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]khaled ali[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sumr road[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sumil@gmail.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2: Output
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Mr Karim[/TD]
[TD]234, by lane[/TD]
[TD]abc@gmail.com[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr rashed[/TD]
[TD]015987456[/TD]
[TD]365 by lane mc road[/TD]
[TD]amik@yahoo.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr Sumon[/TD]
[TD]sumon@bd.net[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]khaled ali[/TD]
[TD]sumr road[/TD]
[TD]sumil@gmail.com[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance