需要一个好方法使用Delphi在平面表中“旋转”（pivot？）数据

I have a data table with records that have a repeated field 'position' - imagine a rotating table with 4 positions each numbered 1 to 4 inc. I store 4 database table rows for each rotation and each row contains the rotation position 1 to 4 inc, so this position field goes 1,2,3,4,1,2,3,4,1,2 etc. An example would be:I have a data table with records that have a re