Create Blanks for every record after the first row

[wonka1234]

Hi,

How can I create only one  record for columns 2, 3, 4 here.

Name	1	2	Percent
Louis	120	107834	0.11%
Ren	120	107834	0.11%
Steven	120	107834	0.11%
Irene	120	107834	0.11%
Tom	120	107834	0.11%
Tawny	120	107834	0.11%
Monique	120	107834	0.11%
Alan	120	107834	0.11%
Bernard	120	107834	0.11%
Larry	120	107834	0.11%

expected output -

Name	1	2	Percent
Louis	120	107834	0.11%
Ren
Steven
Irene
Tom
Tawny
Monique
Alan
Bernard
Larry

[caltang · Accepted solution]

You can try this:

[caltang]

If you want to make it dynamic, you have to have a dimension which distinguishes where the start and end points are for your data. In your current example, I am assuming that the names given are the start and end points of your data, and since you only want the first row, I will only provide you the first row and nullify everything else. So do be mindful of that...