Hi,
I am looking for a code that will help with what I want to achieve. I have a table where I have to split a column using text-to-columns. The number of columns created after will vary time to time.
What I now want to do is copy the rows to a certain column and then for each of the columns created after text-to-column, input the data and repeat the process until the last create column has data.
e.g my table looks like this
<tbody>
</tbody>
So I need to split the items columns which will then show my table as:
<tbody>
</tbody>
So I now want to be able to copy the id and names and bring back the items until the last cell so my end table will look like this:
<tbody>
</tbody>
I might be asking a lot for this to happen but wondered if there was a way this could be achieved.
Appreciate any help that is given.
Kind regards
Hetal
I am looking for a code that will help with what I want to achieve. I have a table where I have to split a column using text-to-columns. The number of columns created after will vary time to time.
What I now want to do is copy the rows to a certain column and then for each of the columns created after text-to-column, input the data and repeat the process until the last create column has data.
e.g my table looks like this
ID | Name | Items |
1 | J Bloggs | Table,Chairs,Desk,Stapler |
2 | R Bear | Chair |
3 | P Parrot | Desk,Table |
<tbody>
</tbody>
So I need to split the items columns which will then show my table as:
ID | Name | Item1 | Item2 | Item3 | Item4 |
1 | J Bloggs | Table | Chairs | Desk | Stapler |
2 | R Bear | Chair | |||
3 | P Parrot | Desk | Table |
<tbody>
</tbody>
So I now want to be able to copy the id and names and bring back the items until the last cell so my end table will look like this:
ID | Name | Item |
1 | J Bloggs | Table |
2 | R Bear | Chair |
3 | P Parrot | Desk |
1 | J Bloggs | Chairs |
3 | P Parrot | Table |
1 | J Bloggs | Desk |
1 | J Bloggs | Stapler |
<tbody>
</tbody>
I might be asking a lot for this to happen but wondered if there was a way this could be achieved.
Appreciate any help that is given.
Kind regards
Hetal