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>
<TBODY>
</TBODY><o></o>
<o>
Table B</o>
<TBODY>
</TBODY><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></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>
Date<o></o> | Ball 1<o></o> | Ball 2<o></o> | Ball 3<o></o> | Bonus<o></o> |
01-Jun<o></o> | 11<o></o> | 13<o></o> | 24<o></o> | 9<o></o> |
08-Jun<o></o> | 8<o></o> | 9<o></o> | 13<o></o> | 14<o></o> |
15-Jun<o></o> | 3<o></o> | 4<o></o> | 16<o></o> | 27<o></o> |
22-Jun<o></o> | 8<o></o> | 24<o></o> | 12<o></o> | 34<o></o> |
29-Jun<o></o> | 7<o></o> | 13<o></o> | 25<o></o> | 4<o></o> |
06-Jul<o></o> | 16<o></o> | 24<o></o> | 27<o></o> | 44<o></o> |
13-Jul<o></o> | 12<o></o> | 7<o></o> | 24<o></o> | 32<o></o> |
20-Jul<o></o> | 1<o></o> | 3<o></o> | 17<o></o> | 31<o></o> |
27-Jul<o></o> | 12<o></o> | 13<o></o> | 14<o></o> | 37<o></o> |
03-Aug<o></o> | 3<o></o> | 5<o></o> | 9<o></o> | 15<o></o> |
10-Aug<o></o> | 14<o></o> | 15<o></o> | 17<o></o> | 18<o></o> |
<TBODY>
</TBODY>
<o>
Table B</o>
Date<o></o> | Number<o></o> | Bonus |
<o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> |
<TBODY>
</TBODY>
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
Last edited: