将多行 CSV 记录作为列数据导入电子表格

Question

有没有标准修复方法可以将多行 CSV 记录转换为列数据（如 CSV 或 LibreOffice）？我正在使用 ArchLinux，并且有 LibreOffice（以及 Python，值得一提）。

我有一个 CSV 文件，其中的记录格式如下：

"field1","value1"
"field2","value2"
"field3","value3"

"field1","value1"
"field2","value2"
"field3","value3"

"field1","value1"
"field2","value2"
"field3","value3"

我想将数据调整为列格式：

"field1","field2","field3"
"value1","value2","value3"
"value1","value2","value3"
"value1","value2","value3"

我在 LibreOffice 打开菜单中没有看到任何相关内容。