AutoFill

[RR8]

Hi All

I have a set of data and in Field 3 (F3)  3 rows down I have a reference I want to add to a new column called reference and copy from start to length of the  entire dataset (same reference)

Please can someone help me

Thank you

[OllieClarke]

Hey @RR8 could you share some sample data to help us help you please?

[RR8]

yes sure and thanks

F1     F2      F3                           new field needed REF

x       10                                             123

x       7                                                123

x       9      REF:123                             123  

[Luke_C]

Hi @RR8 

Here's an example using the append fields tool. I approached it by:

1. Filter: Isolate the record we want to apply to all fields
2. Formula: Create 'REF' field by taking the value in the 3rd column and removing the 'REF:' part.
3. Append fields: Append the REF field back to the dataset 

[Qiu]

@RR8 
Tried with a different approach with a bit more data.

[RR8]

 thanks to you both so much really appreciated