Please I need help with using Data, Text to column to convert numbers in multiple columns into a single column.
<o
></o
>
In Table A below, I have 5 columns. However, I wish to convert the table into a 3-column table of Date, Numbers and Bonus (as shown in Table B below). I want to be able to use Data, Text to column to convert the numbers in Ball 1, Ball2 and Ball 3 columns into a single column named ‘Numbers’ - with each number shown against the relevant date in the date column.
<o
></o
>
<o
></o
>
<o
></o
>
<o
>Table A
</o
>
[TABLE="class: MsoNormalTable, width: 2"]
<TBODY>[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 45, bgcolor: transparent"]
[/TD]
[TD="width: 43, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[/TR]
</TBODY>[/TABLE]
<o
></o
>
<o
>
Table B</o
>
[TABLE="class: MsoNormalTable, width: 135"]
<TBODY>[TR]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 64, bgcolor: transparent"]
[/TD]
[TD="width: 57, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]<o
></o
>
[/TD]
[TD="width: 57, bgcolor: transparent"]<o
></o
>
[/TD]
[/TR]
</TBODY>[/TABLE]
<o
></o
>
I'll appreciate help with the correct steps I should take to achieve the conversion.
Thank you all for your anticipated help.
<o
></o
>Kenny
<o


In Table A below, I have 5 columns. However, I wish to convert the table into a 3-column table of Date, Numbers and Bonus (as shown in Table B below). I want to be able to use Data, Text to column to convert the numbers in Ball 1, Ball2 and Ball 3 columns into a single column named ‘Numbers’ - with each number shown against the relevant date in the date column.
<o


<o


<o


<o

</o

[TABLE="class: MsoNormalTable, width: 2"]
<TBODY>[TR]
[TD="width: 59, bgcolor: transparent"]
Date<o
></o
>


[TD="width: 47, bgcolor: transparent"]
Ball 1<o
></o
>


[TD="width: 45, bgcolor: transparent"]
Ball 2<o
></o
>


[TD="width: 43, bgcolor: transparent"]
Ball 3<o
></o
>


[TD="width: 47, bgcolor: transparent"]
Bonus<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
01-Jun<o
></o
>


[TD="width: 47, bgcolor: transparent"]
11<o
></o
>


[TD="width: 45, bgcolor: transparent"]
13<o
></o
>


[TD="width: 43, bgcolor: transparent"]
24<o
></o
>


[TD="width: 47, bgcolor: transparent"]
9<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
08-Jun<o
></o
>


[TD="width: 47, bgcolor: transparent"]
8<o
></o
>


[TD="width: 45, bgcolor: transparent"]
9<o
></o
>


[TD="width: 43, bgcolor: transparent"]
13<o
></o
>


[TD="width: 47, bgcolor: transparent"]
14<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
15-Jun<o
></o
>


[TD="width: 47, bgcolor: transparent"]
3<o
></o
>


[TD="width: 45, bgcolor: transparent"]
4<o
></o
>


[TD="width: 43, bgcolor: transparent"]
16<o
></o
>


[TD="width: 47, bgcolor: transparent"]
27<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
22-Jun<o
></o
>


[TD="width: 47, bgcolor: transparent"]
8<o
></o
>


[TD="width: 45, bgcolor: transparent"]
24<o
></o
>


[TD="width: 43, bgcolor: transparent"]
12<o
></o
>


[TD="width: 47, bgcolor: transparent"]
34<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
29-Jun<o
></o
>


[TD="width: 47, bgcolor: transparent"]
7<o
></o
>


[TD="width: 45, bgcolor: transparent"]
13<o
></o
>


[TD="width: 43, bgcolor: transparent"]
25<o
></o
>


[TD="width: 47, bgcolor: transparent"]
4<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
06-Jul<o
></o
>


[TD="width: 47, bgcolor: transparent"]
16<o
></o
>


[TD="width: 45, bgcolor: transparent"]
24<o
></o
>


[TD="width: 43, bgcolor: transparent"]
27<o
></o
>


[TD="width: 47, bgcolor: transparent"]
44<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
13-Jul<o
></o
>


[TD="width: 47, bgcolor: transparent"]
12<o
></o
>


[TD="width: 45, bgcolor: transparent"]
7<o
></o
>


[TD="width: 43, bgcolor: transparent"]
24<o
></o
>


[TD="width: 47, bgcolor: transparent"]
32<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
20-Jul<o
></o
>


[TD="width: 47, bgcolor: transparent"]
1<o
></o
>


[TD="width: 45, bgcolor: transparent"]
3<o
></o
>


[TD="width: 43, bgcolor: transparent"]
17<o
></o
>


[TD="width: 47, bgcolor: transparent"]
31<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
27-Jul<o
></o
>


[TD="width: 47, bgcolor: transparent"]
12<o
></o
>


[TD="width: 45, bgcolor: transparent"]
13<o
></o
>


[TD="width: 43, bgcolor: transparent"]
14<o
></o
>


[TD="width: 47, bgcolor: transparent"]
37<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
03-Aug<o
></o
>


[TD="width: 47, bgcolor: transparent"]
3<o
></o
>


[TD="width: 45, bgcolor: transparent"]
5<o
></o
>


[TD="width: 43, bgcolor: transparent"]
9<o
></o
>


[TD="width: 47, bgcolor: transparent"]
15<o
></o
>


[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]
10-Aug<o
></o
>


[TD="width: 47, bgcolor: transparent"]
14<o
></o
>


[TD="width: 45, bgcolor: transparent"]
15<o
></o
>


[TD="width: 43, bgcolor: transparent"]
17<o
></o
>


[TD="width: 47, bgcolor: transparent"]
18<o
></o
>


[/TR]
</TBODY>[/TABLE]
<o


<o

Table B</o

[TABLE="class: MsoNormalTable, width: 135"]
<TBODY>[TR]
[TD="width: 59, bgcolor: transparent"]
Date<o
></o
>


[TD="width: 64, bgcolor: transparent"]
Number<o
></o
>


[TD="width: 57, bgcolor: transparent"]
Bonus
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
[TR]
[TD="width: 59, bgcolor: transparent"]<o


[/TD]
[TD="width: 64, bgcolor: transparent"]<o


[/TD]
[TD="width: 57, bgcolor: transparent"]<o


[/TD]
[/TR]
</TBODY>[/TABLE]
<o


I'll appreciate help with the correct steps I should take to achieve the conversion.
Thank you all for your anticipated help.
<o


Last edited: