How to populate a googlesheet skipping the number of rows calculated based on the data?

A

artem_apetrov2019-08-13 23:30:37

Google Sheets

artem_apetrov, 2019-08-13 23:30:37

The table on 1 sheet has 3 columns, projects, tasks and one-time labor costs. One task can be mentioned several times if one-time labor costs for it have been tracked more than once.
On the 2nd sheet of the table, you need to display line by line:

1 column project
In the 2nd column, line by line, all the tasks of this project
In column 3, the total time for this task
And then again in 1 column the next project and so on (see screenshot).

Information on 1 sheet may change, that is, the number of projects, tasks and time tracks is not known in advance.
In the screenshot, red highlights what needs to be filled in with formulas / scripts.
I will be glad to any advice!

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Alexander Ivanov, 2019-08-14
@artem_apetrov

It is enough to use the PivotTable. For example, like this https:
//docs.google.com/spreadsheets/d/1zunDbwaRRR ...

D

Dimonchik, 2019-08-14
@dimonchik2013

simple script
https://developers.google.com/apps-script/guides/sheets