Hi, How can I create only one record for columns 2, 3, 4 here. Name12PercentLouis1201078340.11%Ren1201078340.11%Steven1201078340.11%Irene1201078340.11%Tom1201078340.11%Tawny1201078340.11%Monique1201078340.11%Alan1201078340.11%Bernard1201078340.11%Larry1201078340.11% expected output - Name12PercentLouis1201078340.11%Ren Steven Irene Tom Tawny Monique Alan Bernard Larry

Create Blanks for every record after the first row

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

Custom Tools

Accepted answers

caltang

You can try this:

For Wonka.yxmd

All comments

caltang

You can try this:

For Wonka.yxmd

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...

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703