Help with CSV export and

[lfcreds11]

Hi,
I receive a .csv file that lists resources in column A, projects or non project work(BAU) in column B, the state of the projected in column C, their Role in column D, and the percent of time used in E-G (would continue for 12 months). The way is comes out, I need to consolidate it to show as the name of the person, the project, state, role and percent for each month. Is there a way to consolidate this information and then add in the non project time in another column perhaps? I cannot figure out how to transform or transpose this data to be able to pull as a readable report or pivot. Can anyone help with a macro or query?

Sample Export.xlsx
	A	B	C	D	E	F	G
1	Resources List	Project Name	State	Project Role	JAN 2024	FEB 2024	MAR 2024
2	-> Sample, Susan				50	50	50
3	-> Sample, Susan -> Project Work				0	0	0
4		Project 1	Active	Team Member	0	0	0
5		Project 2	Active	Team Member	0	0	0
6	-> Sample, Susan -> Non-Project Work				50	50	50
7		Non-Project Work			50	50	50
8	-> Demo, Debbie				61	50	50
9	-> Demo, Debbie -> Project Work				11	0	0
10		Project 3	Active	Team Member	11	0	0
11	-> Demo, Debbie -> Non-Project Work				50	50	50
12		Non-Project Work			50	50	50
Sheet1

 

[lfcreds11]

Forgot to add rows 2 and 8 for example would be the overall sum of time combing the project and non project work per month.