Hello all,
I'm using Excel 2013. I have a list of names and scores, e.g.
Column A | Column B
Chris | 75%
Chris | 65%
Bob | 85%
Chris | 50%
I need to convert it into a table in the format below:
Chris | 75% | 65% | 50%
Bob | 85%
I've tried pivot tables and I can't seem to get them to do exactly what I want them to do - am I missing something? When more data is added to the columns, the table needs to update to accommodate for this. The list will consist of around a thousand entries. There is an unspecified number of scores for each name in the list.
Thank you in advance for any help you can offer, it's greatly appreciated. If I haven't been clear on anything, please let me know!
I'm using Excel 2013. I have a list of names and scores, e.g.
Column A | Column B
Chris | 75%
Chris | 65%
Bob | 85%
Chris | 50%
I need to convert it into a table in the format below:
Chris | 75% | 65% | 50%
Bob | 85%
I've tried pivot tables and I can't seem to get them to do exactly what I want them to do - am I missing something? When more data is added to the columns, the table needs to update to accommodate for this. The list will consist of around a thousand entries. There is an unspecified number of scores for each name in the list.
Thank you in advance for any help you can offer, it's greatly appreciated. If I haven't been clear on anything, please let me know!