Because I want to be able to filter/sort by name or birthday which could probably happen before the concatenation but I've now got my data linked to a pivot table in excel. Is there a way to get the rows to still show even if there is no value for that row?
Thank you for your reply, however that won't work because the teams have more fields that need to be shown too. I need it to look like this (but with much more data of course).
I have a list of teams and other info as row headings and a list of people as a column heading. I want to show the persons birthday with their name but don't want to concatenate. Is this possible?