Hi,
I've got a data set that looks like the below
Listing
<tbody>
</tbody>
I would like to be able to create a table from this data set that looks like the below:
<tbody>
</tbody>
The data set is exported from a web program so I can make adjustments but I would rather keep these to a minimum where possible. I've worked with simple tables and pivot tables before but I just can't get my head around how to achieve this.
Thank you!
I've got a data set that looks like the below
Listing
Company | Listing 1 | Listing 2 | Activity a (1) | Activity b (1) | Activity a (2) | Activity b (2) |
Dan | Dan's CDS | Dan's Books | Jan 30 | Feb 12 | April 9 | Jan 20 |
Bob | Bob's DVDs | Bob's Plates | Jan 2 | March 8 | Jan 2 | Jan 30 |
<tbody>
</tbody>
I would like to be able to create a table from this data set that looks like the below:
Jan | Feb | Mar | April | |
week 1 | Activity a / Bob's DVDs Activity a / Bob's plates | Activity B / Bob's DVDs | ||
week 2 | Activity B / Dan's CDs | Activity A / Dan's Books | ||
week 3 | Activity B / Dan's Books | |||
week 4 | Activity a / Dan's CDs Activity B / Bob's Plates |
<tbody>
</tbody>
The data set is exported from a web program so I can make adjustments but I would rather keep these to a minimum where possible. I've worked with simple tables and pivot tables before but I just can't get my head around how to achieve this.
Thank you!