sum data when column present same text

[arieta]

Hello, I would like to sum certain numerical data together, when some columns present the same text data. Please see below an example of how my data look.

How data look now:

Row #	A	B	C	D	Data1	Data2	Data3
1	Disease	ALL TYPES	FIRST	SECOND	3	4	8
2	Disease	HORMONE	SECOND	FIRST	2	6	3
3	Disease	HORMONE	FIRST	THIRD	1	3	1
4	Disease	HORMONE	SECOND	FIRST	5	1	2
5	Disease	ALL TYPES	FIRST	FIRST	3	4	2
6	Disease	HER2	THIRD	ALL LINES	1	2	4
7	Disease	HORMONE	FIRST	THIRD	5	3	1
8	Disease	HER2	THIRD	ALL LINES	3	1	2

How I want my data to look

A	B	C	D	Data1	Data2	Data3
Disease	ALL TYPES	FIRST	SECOND	3	4	8
Disease	HORMONE	SECOND	FIRST	7	7	5
Disease	HORMONE	FIRST	THIRD	6	6	2
Disease	ALL TYPES	FIRST	FIRST	3	4	2
Disease	HER2	THIRD	ALL LINES	4	3	6

For example, rows 3 and 7 (1st table) present the same text (columns A-D), so in these cases I would like to sum the respective data from columns ‘Data1’, ‘Data2’, and ‘Data3’.

Thank you in advance!

[kelsey_kincaid]

 Hi @arieta -

Have you tried a Summarize tool? You can group by several fields and then sum by your numeric columns. Let me know if that works!

[Jonathan-Sherman · Accepted solution]

Hi @arieta,

You'll want to use a summarise tool for this:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan