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.
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?
Thanks, will post later today.
Will post later today.
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.
Sorry as I think about my questions, I beleive the row should be column.