Hello - I have a Google Sheet that is designed in such a way that some of the columns (8 total) are repeated 10 times. An example of the structure is:Time|Name|Date|Report|From Time|To Time|Activity|Location|District|Neighborhood|Activity|More?If "More" for the data entry of the form is set to "Y", the following columns are repeated for additional data entry:From TimeTo TimeActivityLocationDistrictNeighborhoodActivityMore?When the Google Sheet is added as a reader, the repeated columns have a 00 to 08 appended to them.What I need to do is, based on "More" being set to "Y" for a user (i.e., Name, Date), create N number of rows taking the values from the 00 to 08 columns to create the subsequent rows.I've played with AttributeExploder, Aggregator in my current workspace but I'm stuck! :)A push would be great from the community.Thanks in advance!

Question

Create Rows Based on Column Values in a Google Sheet

Forum|Forum|7 years ago
October 31, 2018
3 replies
39 views

bcrowley10

Hello - I have a Google Sheet that is designed in such a way that some of the columns (8 total) are repeated 10 times. An example of the structure is:

If "More" for the data entry of the form is set to "Y", the following columns are repeated for additional data entry:

From Time
To Time
Activity
Location
District
Neighborhood
Activity
More?

When the Google Sheet is added as a reader, the repeated columns have a 00 to 08 appended to them.

What I need to do is, based on "More" being set to "Y" for a user (i.e., Name, Date), create N number of rows taking the values from the 00 to 08 columns to create the subsequent rows.

I've played with AttributeExploder, Aggregator in my current workspace but I'm stuck! :)

A push would be great from the community.

Thanks in advance!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.