Copy First Row value to rest rows for all fields

[k3pineapple]

Hi all,

Seeking your help to design a section copy all values from first row to rest rows. 

Since the matrix I have is over 30 columns & 5k rows of data. required a dynamic copying solution. Much Appreciated

Sample Input

ID	name	product	type	mode	source	group	AType
123	CAC31	Apple	user	1	2	1	Bus
341
567

Sample output

ID	name	product	type	mode	source	group	AType
123	CAC31	Apple	user	1	2	1	Bus
341	CAC31	Apple	user	1	2	1	Bus
567	CAC31	Apple	user	1	2	1	Bus

[ShankerV · Accepted solution]

Hi @k3pineapple 

Please use the below macro to achieve your output.

multi-row -field -column macro

Note: If we need to apply for 1 column it is recommended to use multi-row formula with below.

IF Isempty([name])
THEN [Row-1:name]
ELSE [name]
ENDIF

As it is for more than 1 columns, it is recommends to use the macro which will do the job in one step.

Many thanks

Shanker V

[Christina_H · Accepted solution]

Sample the first row, then append to all other rows.  Just need to sort out which columns to keep from the original and which to take from the first row.

[binuacs · Accepted solution]

@k3pineapple one way of doing this