Copy First Row value to rest rows for all fields

Question

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

IDnameproducttypemodesourcegroupAType123CAC31Appleuser121Bus341       567

Sample output

IDnameproducttypemodesourcegroupAType123CAC31Appleuser121Bus341CAC31Appleuser121Bus567CAC31Appleuser121Bus

ShankerV · Accepted Answer

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 Answer

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.

binu_acs · Accepted Answer

@k3pineapple one way of doing this