Forum Discussion
Locco
Helper III
Helper IIIMerge names in a row
I need to merge names in a single row and I have been having trouble getting this to work. I would like to do this without using DAX and to have it in query but I am open to a DAX solution as well. ...
Hi Locco ,
Assume you have grouped the machines.
First add an index column to the table.
Then select the index column and use pivot feature.
At last, merge the selected columns(under Add column tag) and delete unneeded columns.
Best Regards,
Jay
Hi Locco ,
Assume you have grouped the machines.
First add an index column to the table.
Then select the index column and use pivot feature.
At last, merge the selected columns(under Add column tag) and delete unneeded columns.
Best Regards,
Jay