Forum Discussion
Consolidating data
Hello,
I have a column of data with a number of different medications that I would like to convert to a single term into a new column, any help would be appreciated as I am a newbie.
Eric
Anonymous ,
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/singlecellextract-in-power-bi/td-p/640094
2 Replies
Hi Eric,
Can you provide some sample values about how you want the end result? The following link might help you.
https://community.powerbi.com/t5/Desktop/Transpose-Transform-Multiple-Rows-into-Single-Row/td-p/381966
https://community.powerbi.com/t5/Desktop/how-to-merge-multiple-rows-into-one-row-with-different-column/m-p/79866#M33288Thanks,
SuhasAkole
Anonymous ,
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/singlecellextract-in-power-bi/td-p/640094
