comments | serial no. | model no. | part no | date |
serial :1235468 model: III-5400 part :tab3gd1 D:05/08/2018 | ||||
56788 III-555 gac56r1 05/08/2018 |
<tbody>
</tbody>
Please I need help in this matter.
I have over than 300 rows.
and I have a column of comments with data in each cells that need split the data in it into 4 columns. or 5
so what am thinking some of the comments have the same name in the column
meaning if there is a way to find serial in the comment copy it and paste under the column serial no,find model copy it and paste under model no,find D and put it under date ,etc.
and to highlight the cells with any color just to know what was pasted because some of the comments does not have the serial,part,model or D in it..which I will handle later (which will be not highlighted)
can some one help find a way to this..even if we can make it column by column
thank you