Marge the cells

Feras95p

Dear all,

I have an excel file which contains the information of a restaurant orders, what I'm looking for is to group each order with a unique row to make it easier to be observed. Below I attached the picture of the input file which will be as input in the work flow:

   And here is the output file which I made it manually and I'm looking to be done by alteryx.

Any idea on how it can be done or any help in that please?

I also attached the excel files.

Thanks in advance for your kind support .

output.xlsx

Input.xlsx

DannyS

HI @Feras95p 

I would go ahead and look at the example workflow attached above ^^^ by @smoskowitz to get you on the right track. This example workflow will not mimic the exact "merge cells" format like in Excel, but you can concatenate the records several ways. The example from @smoskowitz shows the "," separator but her is a list of things you can do to customize the concatenation process:

• Start: The character specified will appear at the beginning of the concatenated string. It is left blank by default.
• Separator: The character specified will appear in between each value of the concatenated string. The default is a comma ,.
• End: The character specified will appear at the end of the concatenated string. It is left blank by default.

The start, separator and end elements must be specified for each field an action is being applied to. You can enter any character or string, or leave them blank. Supported escape characters include: \n (new line), \t (tab), \r (carriage return), and \s (white space character).

You can also rename the columns to your liking within the Summarize tool under the "Output Field Name" column for consistency.

One other thing I would mention is that it looks like some record values within your columns may contain misspellings or slight variations (e.g. Orajah vs Orijah and South 1 vs South1). I would suggest either using the replace function with the Formula tool or looking into the Fuzzy Match tool to clean up those slight variations. This link will give you an example of configuring the tool: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485

I've attached a workflow similar to the above, but with that added formula tool and different separator option.

merge_cells.yxmd