How to split excel file

[joannasokolowska]

Dear colleagues,

I would like to ask you about how I can split one excel file which contains information about each person in the same TAB (excel file attached). There is always the same number of rows with information about the report which are not needed. 

Report
Number 23456
date 01.07.2020
Data for John Smith
		January	February	March
	module 1	103	203	0.5
	type 05	55	102	0.6
	module 3	80	100	0.5
Report
Number 01020
date 01.07.2020
Data for Anna Green
		January	February	March
	module 1	103	203	0.5
	module 2	55	102	0.6
	extract 3	80	100	0.5
	part 2	20	11	80

Desired outcome is like this (under each month summary data from all rows for each person) 

Name	January	February	March
Anna Green	258	416	81.6
John Smith	238	405	1.6

Thank you in advance,

Asia

[atcodedog05]

Hi @joannasokolowska 

Can you provide a sample data.

[joannasokolowska]

sure! please see attached.

[atcodedog05]

@joannasokolowska 

This would be challenging 😅

[joannasokolowska]

I know! but I hope there is some solution 🙂 

[atcodedog05]

Hi @joannasokolowska 

Ok let me give one more shot now🙂

[atcodedog05 · Accepted solution]

Hi @joannasokolowska 

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[joannasokolowska]

You're awesome! Thank you so much for a quick help! 

[atcodedog05]

Happy to help 🙂 @joannasokolowska 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂