Move a range, or a set of cells, to a new area with a simple formula that's just "curly brackets". Very easy and simple to use once you know it.
Academy ↓
Hey there stranger!
Move Cells to New Row with Formula
About this Tutorial
Sheet Resources
Video Transcript
0:00 Okay, so you have these three sort of sets of ranges or cells and you want to move them all into one column here But for some reason you may not want to click Get the little hand click and drag them over for perhaps You're doing something like adding to this score and you need someone else to be inputting
0:21 data But you don't want them to have to go down to another row and find it to add it Maybe you want them to continue adding this way or you have some data that you just want a formula to always update Instead of having to copy and paste this or move this by hand Again, you can sort of do this, you can
0:39 do Command X, cut and paste if you want You can even just copy and paste here and copy and paste Copy this and paste here, right?
0:50 But again, you just want to do this with a formula. I'll show you a really simple formula that's not even named, it's just using curly brackets.
0:59 What we're going to do is do an equal sign here and do curly brackets, just one curly bracket. Actually, we can end that.
1:06 And inside, we're going to separate two ranges, range 1 with a semicolon and range 2. But what are those ranges?
1:13 This range 1 is going to be C, let's say, 2 colon D7. It is this range here highlighted. And the second range here is going to be E2 colon F7 over here, and you can see it highlighted.
1:30 And now, if I hit enter, I have moved these over here. But if I update this, so 89, see it's updated here as well.
1:40 So any updates to these scores here will update it in this column. Now, what's really cool is you can actually do a lot of like averages or data analysis of these scores.
1:48 Some, some ifs pretty easily here because they're all in one column. And you can also keep adding to this. So let's add another column to the right.
1:57 And if we say we have, let's say we have some more scores, and let's just color this a little bit differently.
2:04 Red. We have different scores here. And we want to update this. We just go to our original formula here, and add another semicolon, and add G2 colon H7.
2:22 And there we go. We have added. That new score, this new set of scores, this new range, we've added that to the end of here.
2:29 And that's really cool, uh, to be able to update this pretty easily, pretty simply, uh, without having to edit this formula too much.
2:36 But again, we're using curly brackets here, and so that's a formula that you won't find, uh, anywhere else, this curly brackets is not named,
0:21 data But you don't want them to have to go down to another row and find it to add it Maybe you want them to continue adding this way or you have some data that you just want a formula to always update Instead of having to copy and paste this or move this by hand Again, you can sort of do this, you can
0:39 do Command X, cut and paste if you want You can even just copy and paste here and copy and paste Copy this and paste here, right?
0:50 But again, you just want to do this with a formula. I'll show you a really simple formula that's not even named, it's just using curly brackets.
0:59 What we're going to do is do an equal sign here and do curly brackets, just one curly bracket. Actually, we can end that.
1:06 And inside, we're going to separate two ranges, range 1 with a semicolon and range 2. But what are those ranges?
1:13 This range 1 is going to be C, let's say, 2 colon D7. It is this range here highlighted. And the second range here is going to be E2 colon F7 over here, and you can see it highlighted.
1:30 And now, if I hit enter, I have moved these over here. But if I update this, so 89, see it's updated here as well.
1:40 So any updates to these scores here will update it in this column. Now, what's really cool is you can actually do a lot of like averages or data analysis of these scores.
1:48 Some, some ifs pretty easily here because they're all in one column. And you can also keep adding to this. So let's add another column to the right.
1:57 And if we say we have, let's say we have some more scores, and let's just color this a little bit differently.
2:04 Red. We have different scores here. And we want to update this. We just go to our original formula here, and add another semicolon, and add G2 colon H7.
2:22 And there we go. We have added. That new score, this new set of scores, this new range, we've added that to the end of here.
2:29 And that's really cool, uh, to be able to update this pretty easily, pretty simply, uh, without having to edit this formula too much.
2:36 But again, we're using curly brackets here, and so that's a formula that you won't find, uh, anywhere else, this curly brackets is not named,