具有垂直列出的多个列条目的表 [英] Table with multiple column entries listed vertically

问题描述

我收到了一份包含60,000多条记录和9列的Excel工作表。最后一列包含垂直列出的每个记录的多个条目，这些条目主要创建具有数据单元格的空行。最后一列实际上应该是另外四列。如何将带有垂直条目的记录水平列入其他列？


我有什么（示例）...

I received an Excel work sheet with 60,000+ records and 9 columns. The last column is laced with multiple entries per record listed vertically which creates mostly empty rows with on cell of data. The last column should actually be four additional columns. How do I get the records with vertical entries to list horizontally into additional columns?

What I have (example)...

<跨度类= codeLink 的onclick = 模糊（此，this.parentNode.parentNode，的getChildren（本），TRUE）;>展开 <跨度类= codeDivider> | <跨度类= codeLink 的onclick = 全选（本）;>选择 <跨度类= codeDivider> | <跨度类= codeLink的onclick = 自动换行（在此）;>裹 <跨度类= codeDivider> | <跨度类= codeLink 的onclick = LineNumbers（本）;>行号

推荐答案

您想要存储它的方式是非标准化的并且是错误的形式。它应该被分成一个不同的表，每一行都有一行。

The way you want to store it is unnormalized and is bad form. It really should be separated out into a different table with a row for each line.

Rabbit，


感谢您的回复。我知道它的不良形式（违反2NF），我正在努力解决这个问题。


我正准备打印生产的数据文件。列将是我的程序中调用的数据头。但是，该程序不会识别具有一列垂直列出多个条目的记录的多个条目。


我们将非常感谢任何建议！

Rabbit,

Thanks for the response. I know its bad form (violates 2NF) and I''m trying to fix that.

I''m prepping a data file for print production. The columns will be data headers that are called in my program. However the program won''t recognize multiple entries for a record that has one column listing multiple entries vertically.

Any suggestions would be greatly appreciated!

那么，在这种情况下，导入数据后，可以使用交叉表查询进行非规范化数据。具体情况取决于您如何将数据导入Access。

Well, in that case, after you import the data, you can use a crosstab query to denormalize the data. The specifics will depend on how you are importing the data into Access.

这篇关于具有垂直列出的多个列条目的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！