Excel - 将文本相乘并在一列中排序 [英] Excel - Multiply text and sort in one column

问题描述

我使用多个关键字并定位到一个县的当地城市.很多时候，我会针对 20-50 个城市定位 50-100 个关键字.我需要以某种方式列出这些关键字.

I work with multiple keywords and target local cities in a county. Many times I will be targeting 50 - 100 keywords for 20-50 cities. I need these keywords listed a certain way.

例如:如果我有 5 个针对 5 个城市的关键字，我需要在一个 Excel 列中列出总共 25 个关键字.这仅取决于我的项目将使用多少关键字以及我将定位多少城市.

For example: If I have 5 keywords targeting 5 cities, I would need a list of 25 total keywords in one excel column. It just depends on my project how many keywords I will be using and how many cities I will target.

所以如果我有一个列表:

So if I have a list of:

keyword1
keyword2
keyword3
keyword4    
keyword5

由于我将定位 5 个城市，因此每个关键字都需要乘以 5.

Since I would be targeting 5 cities, each keyword would need to be multiplied by 5.

需要能够将该列表添加到 excel 并让它创建一个这样的列表，我可以复制出来:

Need to be able to add that list to excel and have it create a list like this I can copy out:

keyword1    
keyword1    
keyword1    
keyword1    
keyword1    
keyword2    
keyword2    
keyword2    
keyword2    
keyword2    
keyword3    
keyword3    
keyword3    
keyword3    
keyword3    
keyword4    
keyword4   
keyword4    
keyword4    
keyword4    
keyword5    
keyword5    
keyword5    
keyword5    
keyword5

有什么想法吗?感谢您的帮助！

Any thoughts? Thanks for the help!

推荐答案

在要开始列表并向下复制的第一行中使用此公式.

Use this formula in the first row where you want to start your list and copy down.

=INDEX(A:A,QUOTIENT(ROW(1:1)-1,5)+1)

这篇关于Excel - 将文本相乘并在一列中排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！