merging a 4 by 3 matrix into 1 by 3 matrix

[GarMIngle]

I have patterns of 4 by 3 matrices, with the first column having the same corporate id.  wanted to make a 1 by 3 matrix using the corporate id as the merging column. 

[joshuaburkhow]

Hey @GarMIngle 

Would you be able to provide a dataset as an example to ensure we can answer your question correctly. Also when you say "Merge" what does that mean exactly? Do you want to sum the values or maybe concatenate the values? 

[GarMIngle]

Thanks, will post later today.   

[GarMIngle]

Will post later today.

[GarMIngle]

Thanks for the questions, I managed through trial and error to get what I think I need, 

I took things in various columns and concatenate them into one row; such as

Office SuppliesFurnitureOffice SuppliesOffice Supplies 

Office SuppliesTechnology

Now I want to parse the long string as follows

Office Supplies,Furniture,Office Supplies,Office Supplies

Office Supplies,Technology

I want to use a Furniture and Technology in a formulae with another row.

[GarMIngle]

Sorry as I think about my questions, I beleive the row should be column.