copying records to downward dynamically

[rehanemis]

Hi,

I have spread sheet and wants it to be in new order.

Existing sheet Records
[TABLE="width: 500"]
<tbody>[TR]
[TD]Roll No[/TD]
[TD]Name[/TD]
[TD]Ph1[/TD]
[TD]ph2[/TD]
[TD]ph3[/TD]
[TD]ph4[/TD]
[TD]ph5[/TD]
[TD]ph6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]abc[/TD]
[TD]0300[/TD]
[TD]677[/TD]
[TD]748[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]def[/TD]
[TD]767[/TD]
[TD]87[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]hij[/TD]
[TD]88[/TD]
[TD]88[/TD]
[TD]88[/TD]
[TD]88[/TD]
[TD]88[/TD]
[TD]88[/TD]
[/TR]
</tbody>[/TABLE]

New look i wants as
[TABLE="width: 500"]
<tbody>[TR]
[TD]Roll No[/TD]
[TD]Name[/TD]
[TD]Ph[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]abc[/TD]
[TD]0300[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]abc[/TD]
[TD]677[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]abc[/TD]
[TD]748[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]def[/TD]
[TD]767[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]def[/TD]
[TD]87[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]hij[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]hij[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]hij[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]hij[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]hij[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]hij[/TD]
[TD]88[/TD]
[/TR]
</tbody>[/TABLE]

Is there any way to dynamically adding the rows and records as shown in above example.

any suggestion?

 

[DRSteele]

PowerQuery will unpivot that data in a jiffy. Formula solutions will be more difficult and would require the new functions available in Excel365 Insider.