Hi Alana, Am I correct to assume that you want to concatenate multiple columns in one? Because in that case all you need to do is merge colums. (like I did in the video at 01:00) But I have the feeling that this is not you desired result. Please let me know what is the desired result and I'll be more than happy to help.
@@MMS-PowerBI thank you so much. i wish i could show you an image i have a table with several columns that contain the same type of information. I want to merge all columns in one but without merging rows, keeping them individual. When i merge columns, each row from all columns merges too, and i want to keep each row individual. Let's say stacked instead of merged all together. My final objective is to be able to do group by count and get how many records of each distinct type i have, but if i merge columns it doesn't leave the rows individual and it can not count properly.
I apologize for the late response. Unfortunately this option is not available in Power Query/Power BI. If you have a Linked In account please send me a message with a couple of pictures of a mock up table and the expected result and I might be able to give you another solution. www.linkedin.com/in/marin-stelian-manolescu
Love that most of your tutorials are intermediate/advanced level 👌
Happy to hear that!
Super 👍👍,thanks
Thank You!
I am very happy that you enjoed it!
And How would you merge several columns without merging the rows?
Hi Alana,
Am I correct to assume that you want to concatenate multiple columns in one? Because in that case all you need to do is merge colums. (like I did in the video at 01:00)
But I have the feeling that this is not you desired result.
Please let me know what is the desired result and I'll be more than happy to help.
@@MMS-PowerBI thank you so much. i wish i could show you an image
i have a table with several columns that contain the same type of information.
I want to merge all columns in one but without merging rows, keeping them individual.
When i merge columns, each row from all columns merges too, and i want to keep each row individual. Let's say stacked instead of merged all together.
My final objective is to be able to do group by count and get how many records of each distinct type i have, but if i merge columns it doesn't leave the rows individual and it can not count properly.
I apologize for the late response.
Unfortunately this option is not available in Power Query/Power BI.
If you have a Linked In account please send me a message with a couple of pictures of a mock up table and the expected result and I might be able to give you another solution. www.linkedin.com/in/marin-stelian-manolescu