Hello helpers,
I'm trying to convert a column of information into row to word via excel. Example as below
in Excel
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name1[/TD]
[TD]DOB1[/TD]
[TD]Address1[/TD]
[TD]Title1[/TD]
[/TR]
[TR]
[TD]Name2[/TD]
[TD]DOB2[/TD]
[TD]Address2[/TD]
[TD]Title2[/TD]
[/TR]
</tbody>[/TABLE]
in Word in should look like
Name1,
DOB1,
Address1,
Title1
Name2,
DOB2,
Address2,
Title2
I tried transpose function in excel itself, but it turned out hideous. Any help would be appreciated
I'm trying to convert a column of information into row to word via excel. Example as below
in Excel
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name1[/TD]
[TD]DOB1[/TD]
[TD]Address1[/TD]
[TD]Title1[/TD]
[/TR]
[TR]
[TD]Name2[/TD]
[TD]DOB2[/TD]
[TD]Address2[/TD]
[TD]Title2[/TD]
[/TR]
</tbody>[/TABLE]
in Word in should look like
Name1,
DOB1,
Address1,
Title1
Name2,
DOB2,
Address2,
Title2
I tried transpose function in excel itself, but it turned out hideous. Any help would be appreciated