Hi , have a major problem here with some badly formatted data.
So I have a description of an item and then the item has multiple references against it i.e order reference - these are all on separate lines in the same row!! wrap texted!! really annoying and bad formatting
example table
<tbody>
</tbody>
So the issue I have is I cant do vlookup as I want to put this data in the following format
<tbody>
</tbody>
so each line item has 1 cell, one item reference and 1 description
Is this even possible in excel?
Many thanks in advance this is doing my head in!
cheers
So I have a description of an item and then the item has multiple references against it i.e order reference - these are all on separate lines in the same row!! wrap texted!! really annoying and bad formatting
example table
description | |
blue | 1003 1005 1006 |
yellow | 2550 3440 4444 |
<tbody>
</tbody>
So the issue I have is I cant do vlookup as I want to put this data in the following format
blue | 1003 |
blue | 1005 |
blue | 1006 |
<tbody>
</tbody>
so each line item has 1 cell, one item reference and 1 description
Is this even possible in excel?
Many thanks in advance this is doing my head in!
cheers
Last edited: