课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Stack names with rows in between

Stack names with rows in between - Microsoft Excel教程

课程: Excel Weekly Challenge

开始一个月试用 购买团队方案

Stack names with rows in between

“

- [Instructor] This challenge is based on something real that happened many years ago, back before there was power query, dynamic arrays, and all of these new exciting functions. A friend had over 2,000 names, all in a stack, similar to what you see in column B, and she needed 14 rows between every name. Back then, it took me two days to figure it out and I came up with a pretty elegant solution, but it was rough. I almost want to drop my head in my hands and weep when I think about how hard life was back then, but life is easier for you. And we have name, email, phone in cell B1. You don't see any email or phone, that's why we want to put two rows in between every name so that we have the space for that other data. But right now, time to pause the video and get those spaces between the names. (upbeat music) All right, you're back. Let's see if we can make this quick. I am going to put a plus sign here in cell C2…

内容