Hello all,
My data is as follows:
<tbody>
</tbody>
And so on.
I want to move the Tasks all onto a single row. Have tried manual copy/paste with Transpose but there are too many records for this to be viable
Desired output is:
<tbody>
</tbody>
Any help would be greatly appreciated!
Regards,
Hohums
My data is as follows:
CUSTOMER | ADDRESS | TASK |
CUST1 | ADDR1 | TASK1 |
CUST1 | ADDR1 | TASK2 |
CUST1 | ADDR1 | TASK3 |
CUST2 | ADDR2 | TASK1 |
CUST2 | ADDR2 | TASK2 |
<tbody>
</tbody>
And so on.
I want to move the Tasks all onto a single row. Have tried manual copy/paste with Transpose but there are too many records for this to be viable
Desired output is:
CUST1 | ADDR1 | TASK1 | TASK2 | TASK3 |
CUST2 | ADDR2 | TASK1 | TASK2 | TASK3 |
<tbody>
</tbody>
Any help would be greatly appreciated!
Regards,
Hohums