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:
<tbody>
</tbody>
Here is the transposed table:
<tbody>
</tbody>
And the final step - dividing first column into two. THe splitter is " - "
<tbody>
</tbody>
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:
Workweek | Intern - male | Intern - female | Intern - other |
WW39 | 2 | 1 | 0 |
WW40 | 1 | 0 | 0 |
<tbody>
</tbody>
Here is the transposed table:
type/gender | WW39 | WW40 |
Intern - male | 2 | 1 |
Intern - female | 1 | 0 |
Intern - other | 0 | 0 |
<tbody>
</tbody>
And the final step - dividing first column into two. THe splitter is " - "
type | gender | WW39 | WW40 |
Intern | male | 2 | 1 |
Intern | female | 1 | 0 |
Intern | other | 0 | 0 |
<tbody>
</tbody>
Table should be copied from one permanent tab, let´s call it "Source" into the tab called "Converted data".
Last edited: