Hello!
I have a problem, which can be manually managed through "Sorting, Concatenate and Transpose". However, this method can consume a lot of time, if not days!
Every "comment" I make is entered in Column B @ Sheet 2 and is given a "name" in Column A (each person has more than one comment).
Then, I sort the table in Sheet 2, concatenate all comments per name and paste them according to the name in Sheet 1.
I've attached a sample showing exactly how it should come out.
Thanks in advance for the help!
I have a problem, which can be manually managed through "Sorting, Concatenate and Transpose". However, this method can consume a lot of time, if not days!
Every "comment" I make is entered in Column B @ Sheet 2 and is given a "name" in Column A (each person has more than one comment).
Then, I sort the table in Sheet 2, concatenate all comments per name and paste them according to the name in Sheet 1.
I've attached a sample showing exactly how it should come out.
Thanks in advance for the help!