Hi
I have a spreadsheet which has list of actions and the project they relate to. I would like to tidy up the data to have seperate row with project name and actions underneath. See examples below
Current Format
A1
Task 1 Joanne 15/02/2016 Project A
Task 2 Emily 23/03/2016 Project A
Task 3 Emily 14/03/2016 Project A
Task X David 15/04/2016 Project B
Task Y Joanne 15/04/2016 Project B
Task 10 Fran 13/02/2016 Project C
How I would like it to show
Project A
Task 1 Joanne 15/02/2016
Task 2 Emily 23/03/2016
Task 3 Emily 14/03/2016
Project B
Task X David 15/04/2016
Task Y Joanne 15/04/2016
Project C
Task 10 Fran 13/02/2016
Hope someone can help as I have nearly 200 rows to tidy each week.
I have a spreadsheet which has list of actions and the project they relate to. I would like to tidy up the data to have seperate row with project name and actions underneath. See examples below
Current Format
A1
Task 1 Joanne 15/02/2016 Project A
Task 2 Emily 23/03/2016 Project A
Task 3 Emily 14/03/2016 Project A
Task X David 15/04/2016 Project B
Task Y Joanne 15/04/2016 Project B
Task 10 Fran 13/02/2016 Project C
How I would like it to show
Project A
Task 1 Joanne 15/02/2016
Task 2 Emily 23/03/2016
Task 3 Emily 14/03/2016
Project B
Task X David 15/04/2016
Task Y Joanne 15/04/2016
Project C
Task 10 Fran 13/02/2016
Hope someone can help as I have nearly 200 rows to tidy each week.