I have a large no. of entries in excel like below:
[TABLE="width: 530"]
<colgroup><col span="2"><col><col span="5"></colgroup><tbody>[TR]
[TD][TABLE="width: 530"]
<colgroup><col span="2"><col><col span="5"></colgroup><tbody>[TR]
[TD]BOAT
NO[/TD]
[TD]LOT NO[/TD]
[TD="colspan: 5, align: center"]Density [/TD]
[TD]STATUS[/TD]
[/TR]
[TR]
[TD]F2/146[/TD]
[TD]5820[/TD]
[TD]10.48[/TD]
[TD="align: right"]10.49[/TD]
[TD="align: right"]10.48[/TD]
[TD="align: right"]10.5[/TD]
[TD="align: right"]10.49[/TD]
[TD] ACC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.49[/TD]
[TD="align: right"]10.49[/TD]
[TD="align: right"]10.49[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F2/149[/TD]
[TD]5820[/TD]
[TD]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.44 [/TD]
[TD] RS[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F2/150[/TD]
[TD]5820[/TD]
[TD]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.49[/TD]
[TD="align: right"]10.45[/TD]
[TD="align: right"]10.47[/TD]
[TD] ACC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.47[/TD]
[TD="align: right"]10.46[/TD]
[TD="align: right"]10.48[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F2/153[/TD]
[TD]5843[/TD]
[TD]10.53[/TD]
[TD="align: right"]10.53[/TD]
[TD="align: right"]10.54[/TD]
[TD="align: right"]10.53[/TD]
[TD="align: right"]10.56 [/TD]
[TD] ACC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.55[/TD]
[TD="align: right"]10.55[/TD]
[TD="align: right"]10.55[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F2/154[/TD]
[TD]5843[/TD]
[TD]10.52[/TD]
[TD="align: right"]10.53[/TD]
[TD="align: right"]10.52[/TD]
[TD="align: right"]10.52[/TD]
[TD="align: right"]10.51[/TD]
[TD] ACC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.51[/TD]
[TD="align: right"]10.52[/TD]
[TD="align: right"]10.52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="colspan: 5, align: center"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The boat no. has been assigned a lot no. & 8 density values are recorded in two rows. I want them to arrange in single row against each boat & lot no. for statistical analysis.
Any help will be of great use.
Thanks in advance!
[TABLE="width: 530"]
<colgroup><col span="2"><col><col span="5"></colgroup><tbody>[TR]
[TD][TABLE="width: 530"]
<colgroup><col span="2"><col><col span="5"></colgroup><tbody>[TR]
[TD]BOAT
NO[/TD]
[TD]LOT NO[/TD]
[TD="colspan: 5, align: center"]Density [/TD]
[TD]STATUS[/TD]
[/TR]
[TR]
[TD]F2/146[/TD]
[TD]5820[/TD]
[TD]10.48[/TD]
[TD="align: right"]10.49[/TD]
[TD="align: right"]10.48[/TD]
[TD="align: right"]10.5[/TD]
[TD="align: right"]10.49[/TD]
[TD] ACC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.49[/TD]
[TD="align: right"]10.49[/TD]
[TD="align: right"]10.49[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F2/149[/TD]
[TD]5820[/TD]
[TD]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.44 [/TD]
[TD] RS[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F2/150[/TD]
[TD]5820[/TD]
[TD]10.47[/TD]
[TD="align: right"]10.47[/TD]
[TD="align: right"]10.49[/TD]
[TD="align: right"]10.45[/TD]
[TD="align: right"]10.47[/TD]
[TD] ACC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.47[/TD]
[TD="align: right"]10.46[/TD]
[TD="align: right"]10.48[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F2/153[/TD]
[TD]5843[/TD]
[TD]10.53[/TD]
[TD="align: right"]10.53[/TD]
[TD="align: right"]10.54[/TD]
[TD="align: right"]10.53[/TD]
[TD="align: right"]10.56 [/TD]
[TD] ACC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.55[/TD]
[TD="align: right"]10.55[/TD]
[TD="align: right"]10.55[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F2/154[/TD]
[TD]5843[/TD]
[TD]10.52[/TD]
[TD="align: right"]10.53[/TD]
[TD="align: right"]10.52[/TD]
[TD="align: right"]10.52[/TD]
[TD="align: right"]10.51[/TD]
[TD] ACC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10.51[/TD]
[TD="align: right"]10.52[/TD]
[TD="align: right"]10.52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="colspan: 5, align: center"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The boat no. has been assigned a lot no. & 8 density values are recorded in two rows. I want them to arrange in single row against each boat & lot no. for statistical analysis.
Any help will be of great use.
Thanks in advance!