How can i merge columns but not rows?

[alanarodriguez_]

i got 16 columns to with the same data, i need to merge them, to be able to group by and count such data, but i dont seem to find the right way to do it without affecting the amount of rows. 

See? the same type of data, and categories and everything, i would only need to put it in a column without merging each individual row 

[Ray_Minds]

Hi @alanarodriguez_ 
Please follow below steps
1. Click on Transforrm Data
2. Click on the Transform Tab
3. Select those columns which you want with CTRL + Click
4. Click on the Unpivot only selected column from Unpivot Column drop down
5. Select the column and GroupBy Using Groupby Tab from the Ribon or Right Click on the column which you want to count and click on the GroupBy.
6. Remove the unnecessary columns
7. Close and Apply and Save .

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

[Anonymous]

Hi @alanarodriguez_ 

Could you tell me if your problem has been solved?

If it is, kindly Accept it as the solution. More people will benefit from it.

Or you are still confused about it, please provide me with more details about your problem.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

First and foremost, share data in a format that can be pasted in an MS Excel file.  On that sample data, show the expected result.

[amitchandak]

@alanarodriguez_ , On the way is to unpivot the columns, That will bring all the data under one column. But rows will increase. We usually add an index column before unpivot to make sure we are able to correct calculation using index column later

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g