Hi, I got a sheet where each order are splitted into one row per item. I would like to collect all items from same order into one row - is this possible?
FROM THIS:
<tbody>
</tbody>
TO THIS:
<tbody>
</tbody>
- OR THIS -
<tbody>
</tbody>
Would love some help With this one.
FROM THIS:
| Order | Item |
| 1234 | Red |
| 4567 | Blue |
| 1234 | Yellow |
| 4567 | Brown |
| 1234 | Orange |
<tbody>
</tbody>
TO THIS:
| Order | Item | Item2 | Item3 |
| 1234 | Red | Yellow | Orange |
| 4567 | Blue | Brown | |
| 1234 | Yellow | Red | Orange |
| 4567 | Brown | Blue | |
| 1234 | Orange | Red | Yellow |
<tbody>
</tbody>
- OR THIS -
| Order | Item | Item2 | Item3 |
| 1234 | Red | Yellow | Orange |
| 4567 | Blue | Brown |
<tbody>
</tbody>
Would love some help With this one.
