mklindquist0815
Board Regular
- Joined
- Jul 5, 2015
- Messages
- 63
I have a spreadsheet that has values that looks similar to below (but with multiple IDs)
<tbody>
</tbody>
Is there any possible way to create VBA to squish all the data together for each ID and Class into one row? So that the ending result would look like below?
<tbody>
</tbody>
ID | Class | Submit Date | Post Date | Start Date | Complete Date |
1172739 | ENG102 | 9/7/2015 | |||
1172739 | ENG102 | 9/4/2015 | |||
1172739 | ENG102 | 9/9/2015 | |||
1172739 | ENG102 | 9/3/2015 |
<tbody>
</tbody>
Is there any possible way to create VBA to squish all the data together for each ID and Class into one row? So that the ending result would look like below?
ID | Class | Submit Date | Post Date | Start Date | Complete Date |
1172739 | ENG102 | 9/7/2015 | 9/4/2015 | 9/3/2015 | 9/9/2015 |
<tbody>
</tbody>