Add a character at suffix

Power Query
1

I want to add continuous series of alphabet as suffix starting from A to ZZ in my index column which start from 1.
Example
Index New Column
1 1A
2 2B
3 3C
…
26 26Z
27 27AA
28 28AB
…
and so on.

I get upto Z using
= Table.AddColumn(#"Changed Type", "New Column", each Character.FromNumber([Index] + 64), type text)

2

@abinash
See if this is what you had in mind. It will work from A to ZZ, but after that I dont believe it would work. But should at least provide some sort of methodology.

Final%20Result
Final Result.png571×656 9.51 KB

Suffice continous alphabetic.pbix (12.5 KB)

1 Like
3

Thank for your response. It looks great and resolve my problem.

Thank you :smiley: