Merge data in fields

[Elmin]

Hi all!

I have a difficulties with merging data in fields for certain rows, however the case is a little bit different, so I couldn't find appropriate solution for it so far.

I need to merge the sum of the data for all shops so it shows as in outcome demonstrated. (The last field is just sum column for example).

Thanks everyone for your reply!!!

So the data I have:

PL Line	Shop 1	Shop 2	Shop 3	Totals for lines 13-33
13 Franchise Costs	3,566	0	0	3,566
14 Brand Management Costs	1,756	0	0	1,756
15 Pre Operating Expenses	0	0	0	0
16 Other Income Expense	0	0	0	0
17 Total Brand Contribution	24,592	-7,887	-2,851	13,854
18 Cross Brand Management overheads	0	0	0	0
21 Total Retail Profit before support overheads	24,592	-7,887	-2,851	13,854
22 Supply Chain overheads	3,266	0	0	3,266
23 Total Retail Support Function overheads	20,425	0	0	20,425
24 Total Retail Profit after all Retail overheads	901	-7,887	-2,851	-9,837

The outcome should be:

I wondered whether that even possible in Alteryx?

[Qiu]

@Elmin 

Maybe you can do something like this. It is also dynamic for more columns in case.

[Elmin]

Dear Qiu,

Thanks for your reply, I appreciate it.

However I didn't have difficulties with summarizing the values in data related to the fields.

The thing I need is the table structure to be shown as presented in outcome screenshot.

Thank you!

[Qiu]

@Elmin 
I am sorry for the misunderstanding.

Do you accept output data to a pre-defined templated?

By which, we can have the structure as you need with the option "Preserve Format".

[apathetichell]

My brain is a bit fried and there are probably much better/faster ways to get you here but this should do what you want... you'll need to render the output which will overwrite any existing sheets.

[Elmin]

@apathetichell

Dear, thanks for response, this solution looks like a proper one, but the obstacle is that there are to be 3 separate fields for [Shop 1], [Shop 2], [Shop 3], but with common merged value as in [TOTALS] field. In xlsx it should look like as below:

[Elmin]

Yes, I need the format of the table exactly as on screenshot below:

It needs to have 3 separate fields for each shop, but for lines indicated in the table they need to have common merged and shared values for all three fields.

[atcodedog05 · Accepted solution]

Hi @Elmin 

You can achieve this using merge cells. Sadly its not very straightforward. You need to build different blocks and align as required.

Workflow:

Output:

Hope this helps : )

[Elmin]

Thanks! This works out!