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]

with file
i will do From Folder a bit later

 

[sandy666]

Here is example with FromFile AND FromFolder. Unfold Group FromFolder and do the rest, you know "how to"
Example

 

[anilomevina]

Here is example with FromFile AND FromFolder. Unfold Group FromFolder and do the rest, you know "how to"
Example

I am so sorry but I don't really understand what is unfold group? I am very new to this?

 

[sandy666]

usually all folders/groups are unfolded (expanded) if you open the excel file. Click little black arrow and you see You can Fold/Unfold group(s).
if you see queries like on the picture just double click anastasia

 

[anilomevina]

View attachment 3561
usually all folders/groups are unfolded (expanded) if you open the excel file. Click little black arrow and you see You can Fold/Unfold group(s).
if you see queries like on the picture just double click anastasia

Thank you again!! I cannot believe that you have helped me resolve an issue that took a while with only one line of code!! (I just used your line for the conditional column and then fill down)
Thank you and I wish you all the best

 

[sandy666]

I just used your line for the conditional column and then fill down

Like I said: You know how to

Have a nice day