How can I split datas in vertical into column

LesterRonquillo

New Member
Joined
Aug 30, 2016
Messages
11
What's the fastest way to split datas in vertical into column?

Ex.
[TABLE="width: 357"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Mr. Tom Hanks[/TD]
[/TR]
[TR]
[TD]email@yahoo.com[/TD]
[/TR]
[TR]
[TD]3333 Shadowfern Drive, Houston, TX 77082[/TD]
[/TR]
[TR]
[TD]H: (111) 111-1111[/TD]
[/TR]
[TR]
[TD]Mr. Mel Gibson[/TD]
[/TR]
[TR]
[TD]email@gmail.com[/TD]
[/TR]
[TR]
[TD]555 Lindenwood Drive, Houston, TX 77024 United States[/TD]
[/TR]
[TR]
[TD]H: (222) 222-222[/TD]
[/TR]
[TR]
[TD]Ms. Julia Roberts[/TD]
[/TR]
[TR]
[TD]11914 Heritage Ln, Houston, TX 77024[/TD]
[/TR]
[TR]
[TD]Mr. Antonio Banderas[/TD]
[/TR]
[TR]
[TD]email@hotmail.com[/TD]
[/TR]
[TR]
[TD]H: (333) 333-3333[/TD]
[/TR]
[TR]
[TD]B: (444) 444-4444



I want it to look something like this,

[TABLE="width: 1227"]
<tbody>[TR]
[TD][/TD]
[TD]Name[/TD]
[TD]Email[/TD]
[TD]Address[/TD]
[TD]Contact 1[/TD]
[TD]Contact 2[/TD]
[/TR]
[TR]
[TD]Mr. Tom Hanks[/TD]
[TD]Mr. Tom Hanks[/TD]
[TD]email@yahoo.com[/TD]
[TD]3333 Shadowfern Drive, Houston, TX 77082[/TD]
[TD]H: (111) 111-1111[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]email@yahoo.com[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3333 Shadowfern Drive, Houston, TX 77082[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]H: (111) 111-1111[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr. Mel Gibson[/TD]
[TD]Mr. Mel Gibson[/TD]
[TD]email@gmail.com[/TD]
[TD]555 Lindenwood Drive, Houston, TX 77024 United States[/TD]
[TD]H: (222) 222-222[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]email@gmail.com[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]555 Lindenwood Drive, Houston, TX 77024 United States[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]H: (222) 222-222[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ms. Julia Roberts[/TD]
[TD]Ms. Julia Roberts[/TD]
[TD][/TD]
[TD]11914 Heritage Ln, Houston, TX 77024[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11914 Heritage Ln, Houston, TX 77024[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr. Antonio Banderas[/TD]
[TD]Mr. Antonio Banderas[/TD]
[TD]email@hotmail.com[/TD]
[TD][/TD]
[TD]H: (333) 333-3333[/TD]
[TD]B: (444) 444-4444[/TD]
[/TR]
[TR]
[TD]email@hotmail.com[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]H: (333) 333-3333[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B: (444) 444-4444[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
To make it clearer..

FROM this,

Mr. Tom Hanks
email@yahoo.com
3333 Shadowfern Drive, Houston, TX 77082
H: (111) 111-1111
Mr. Mel Gibson
email@gmail.com
555 Lindenwood Drive, Houston, TX 77024 United States
H: (222) 222-222
Ms. Julia Roberts
11914 Heritage Ln, Houston, TX 77024
Mr. Antonio Banderas
email@hotmail.com
H: (333) 333-3333
B: (444) 444-4444


TO this,

[TABLE="width: 870"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Name
EmailAddressContact 1Contact 2
Mr. Tom Hanksemail@yahoo.com3333 Shadowfern Drive, Houston, TX 77082H: (111) 111-1111
Mr. Mel Gibsonemail@gmail.com555 Lindenwood Drive, Houston, TX 77024 United StatesH: (222) 222-222
Ms. Julia Roberts 11914 Heritage Ln, Houston, TX 77024
Mr. Antonio Banderasemail@hotmail.comH: (333) 333-3333B: (444) 444-4444

<tbody>
</tbody>
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,226,224
Messages
6,189,728
Members
453,566
Latest member
ariestattle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top