|I still don't know what you are looking for.|
First, before posting any more example data in this forum, please click on the blue line at the end of this post and read the instructions on how to post data so that it lines up and is easier for us to read.
As to your question, I see multiple entries of e.g. IMAC with dates in your "spreadsheet" but only one entry of IMAC in your "table".
What is it that you want the "table" to look like when you are done?
(BTW I'm also not sure why you differentiate between a "spreadsheet" and a "table". I assume that all of this data is in an Excel worksheet.)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.