Hi, I have the following data in excel and am looking for a way to split it out into seperate lines - I was thinking Power Query could be the answer but not sure on the steps I could take. It is a one off data clean so I am also up for doing it in Excel via formula but again not certain on the steps to take. It's about 5000 lines of data.
Current Data:
<tbody>
</tbody>
What I would like:
<tbody>
</tbody>
Appreciate any help you could provide!
Current Data:
Website | Items | Price | Quantity |
Ebay | Chair Bed Table | 15 100 50 | 4 1 1 |
Madeup.com | Carpet | 100 | 2 |
Amazon | Lamp Couch | 20 100 | 4 1 |
<tbody>
</tbody>
What I would like:
Website | Items | Price | Quantity |
Ebay | Chair | 15 | 4 |
Ebay | Bed | 100 | 1 |
Ebay | Table | 50 | 1 |
Madeup.com | Carpet | 100 | 2 |
Amazon | Lamp | 20 | 4 |
Amazon | Couch | 100 | 1 |
<tbody>
</tbody>
Appreciate any help you could provide!