Forum Discussion
Solved
Combine data from multiple rows into a single row
Hi Excel community I have a dataset that looks something like this Incident # Name of person reporting Role of person reporting Location of Incident 123 ...
Thanks Jan. That was a quick fix to the problem. I selected the advance option and it allowed me to say how many columns and the default was 2 so I changed it to a number more than what I expect I will need and it has worked perfectly. Thank you
Jilly , nonetheless, when you have more time better to shift on dynamic number of columns generation. That's only 3 lines of code. If, for example, now you have max 4 persons who may report incidents, in a while your business will grow and you add couple of more persons in staff - and have to rebuild the query. Or at least define max number as parameter - it will be easier in maintenance.