I'd love some help here. I have a table in google sheets with a bunch of columns and I'd like to create a new record for each column which has a value of 1. In the picture I've attached you can see what I mean. I have a table that looks like the one at the top in blue and I'd like to transform it to look like the one on the bottom in red. I want to do this transformation so I can get a join key for something I'm doing in Google Data Studio. Thanks in advance for the help!

Also, what are the proper terms for what I'm trying to do, what could I have googled instead to find the answer?

CodePudding user response：

I figured out a solution in case anyone else is interested or has this same problem in the future. The full solution can be found here: