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

example.xlsx

atcodedog05

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 😀👍

data extract.yxmd