Hell everyone!
This is my first time posting on this forum, but I have a fairly basic question.
I have received a data dump with multiple values in a single merged cell that I need to extract into individual rows so I can preform a vlookup on this data.
It looks like this expect on a much larger scale:
<tbody>
</tbody>
What I need is to find a way to extract the "Value" column and "Status" column without having to manually go through and copy and past each value. Basically I need to get the table below:
<tbody>
</tbody>
I have tried looking around but have not found a solution to my problem. If anyone has any advice that would be greatly appreciated.
Have a great day!
This is my first time posting on this forum, but I have a fairly basic question.
I have received a data dump with multiple values in a single merged cell that I need to extract into individual rows so I can preform a vlookup on this data.
It looks like this expect on a much larger scale:
Value | Status |
x1 x2 x3 x4 x5 | Good |
y1 | Bad |
z1 z2 | Pending |
<tbody>
</tbody>
What I need is to find a way to extract the "Value" column and "Status" column without having to manually go through and copy and past each value. Basically I need to get the table below:
Value | Status |
x1 | Good |
x2 | Good |
x3 | Good |
x4 | Good |
x5 | Good |
y1 | Bad |
z1 | Pending |
z2 | Pending |
<tbody>
</tbody>
I have tried looking around but have not found a solution to my problem. If anyone has any advice that would be greatly appreciated.
Have a great day!