Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The pivot table is maybe a somewhat forgotten option, but very versatile, the @w_whalley answer is a demonstration.

Also this can be made with formulas, attached a file with a formula solution. TransformRecords_MultipleLine2OneLineRecord.ods