megatracer
New Member
- Joined
- Jan 21, 2014
- Messages
- 4
Hello all,
I am struggling to transpose the table, plus I would need to split the newly rotated column into two.
Here is an example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Workweek[/TD]
[TD]Intern - male[/TD]
[TD]Intern - female[/TD]
[TD]Intern - other[/TD]
[/TR]
[TR]
[TD]WW39[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]WW40[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
Here is the transposed table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]type/gender[/TD]
[TD]WW39[/TD]
[TD]WW40[/TD]
[/TR]
[TR]
[TD]Intern - male[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Intern - female[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Intern - other[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
And the final step - dividing first column into two. THe splitter is " - "
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]type[/TD]
[TD]gender[/TD]
[TD]WW39[/TD]
[TD]WW40[/TD]
[/TR]
[TR]
[TD]Intern[/TD]
[TD]male[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Intern[/TD]
[TD]female[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Intern[/TD]
[TD]other[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
Table should be copied from one permanent tab, let´s call it "Source" into the tab called "Converted data".

I am struggling to transpose the table, plus I would need to split the newly rotated column into two.
Here is an example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Workweek[/TD]
[TD]Intern - male[/TD]
[TD]Intern - female[/TD]
[TD]Intern - other[/TD]
[/TR]
[TR]
[TD]WW39[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]WW40[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
Here is the transposed table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]type/gender[/TD]
[TD]WW39[/TD]
[TD]WW40[/TD]
[/TR]
[TR]
[TD]Intern - male[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Intern - female[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Intern - other[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
And the final step - dividing first column into two. THe splitter is " - "
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]type[/TD]
[TD]gender[/TD]
[TD]WW39[/TD]
[TD]WW40[/TD]
[/TR]
[TR]
[TD]Intern[/TD]
[TD]male[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Intern[/TD]
[TD]female[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Intern[/TD]
[TD]other[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
Table should be copied from one permanent tab, let´s call it "Source" into the tab called "Converted data".

Last edited: