Power Query - program a column to automatically fill values in

[anilomevina]

Hello and good afternoon,
I was wondering if there is a way to automatically fill column D with AAAABBBBCCCCDDDD(and so on) as part of a Power Query.
Thank you in advance.

 

[sandy666]

select column Point and Transform - Fill - Down

 

[anilomevina]

select column Point and Transform - Fill - Down

I have tried it but it doesn't do anything unfortunately

 

[sandy666]

 

[anilomevina]

View attachment 3502

I think that the problem is that I did not fill ABCD manually, it reads it from a data file(text file), should that make any difference? because I am trying to follow your steps but it just does not do anything at all

 

[sandy666]

is possible to post a link to the shared txt file via GoogleDrive, OneDrive or any similar (if there is no confidential data)?

 

[sandy666]

I only did

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filled Down" = Table.FillDown(Source,{"Point"})
in
    #"Filled Down"

 

[anilomevina]

Example of text files - Google Drive

drive.google.com

I am not sure if I have shared it in the correct way but here are example of two text files (numbers have been changed)

 

[sandy666]

ok, so what I should do with these files? or better, what are you doing with these files?

or do what you want then share result xlsx file the same way as txt files

 

[anilomevina]

ok, so what I should do with these files? or better, what are you doing with these files?

I have created a Query that organises the files in a way where there is a column for Actual and a column for Nominal data. However, for each file, there are ABCD points as well as xyz directions so I am trying to fill the entire point column (that I have screenshooted in my first message) with AAAABBBBCCCCDDDD (each letter repeates itself three times, once for x, once for y and once for z)