Hello,
I have not phrased the title well, but I am trying to work out if there is a way in Excel to group/merge multiple cells from one column into a single cell linked to the entry in another column.
For example I have a sheet with data as in columns A and B, and I am trying to find a way to convert it to look like Columns E and F
excel.jpg
Thank you in advance.
Bookmarks