在Excel中修复粘贴的表格数据（从网站复制） [英] Fix pasted tabular data in Excel (copied from website)

问题描述

我正在从网站复制大量的数据，但由于它没有在表格中列出，它在Excel中以以下格式粘贴：

 法国
欧洲
 
西班牙
欧洲
 
埃及
非洲
  

我试图找到一种在Excel中自动化修复的方法，将其转换为以下格式：

 法国欧洲
西班牙欧洲
埃及非洲
  

我已经尝试创建一个快速的宏来移动较低的单元格的右上角，但我很努力让它工作。有没有一个简单的方法来做这件事，我失踪了，还是会涉及编写VB函数？

解决方案

将你的列复制到立即权利。使用Shift单元格从该列中删除顶部单元格。筛选该列以选择空白单元格并删除这些行。然后过滤您的原始列以选择空白单元格并删除这些行。

I am copying large amounts of data from a website, but because it is not laid out in a table it is pasting in the following format in Excel:

France
Europe

Spain
Europe

Egypt
Africa

I am trying to find a way to automate a 'fix' in Excel to convert it to the following format:

France    Europe
Spain     Europe
Egypt     Africa

I have tried creating a quick Macro to move the lower cells 'up and right' but I am struggling to get it to work. Is there an easy way of doing this that I am missing or will it involve writing a VB function?

解决方案

Copy your column into the one on its immediate right. Delete the top cell from that column with Shift cells up. Filter that column to select blank cells and delete those rows. Then filter your original column to select blank cells and delete those rows.

这篇关于在Excel中修复粘贴的表格数据（从网站复制）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！