Automatic "Numbering" of unique rows with A,B,C.... or AA,AB,AC... with power query

[nahaku]

Hello, I would like to create template where when i insert data it woull add something like numbering but with alphabetic symbols.
It should start from A,B,C... if it makes simplier it could start with AA,AB,AC... because on the end of the day it can be that It will need more symbols then is in basic alphabet, so it will need to combine atleast two letters.
The Location column is basically Unique for each sequence of A,B,C, it should be always reseted for new Location, as on the example what i want to achieve.
Name column will be unique but only within the location, it can be same for multiple Names.
Is there some function I could use in power Query or Excel itself? To create this column of IDs.

IC sorting data.xlsx
	J	K	L	M
1	location	NAME	id	ID VERSION2
2	MSKU8416005	V074-UKAN1008358-N12	A	AA
3	MSKU8416005	V085-UKATPN1000668-N12	B	AB
4	MSKU8416005	V289-UKAN1012044-N10	C	AC
5	MSKU8416005	V289-UKAN1012044-N9	D	AD
6	MSKU8416005	V002-UKAKKOA131073-N12	E	AE
7	MSKU8416005	V009-UKAPLN1011875-N3	F	AF
8	MSKU8416005	V263-UKAKKOA147545-N4	G	AG
9	MSKU8416005	V286-UKAKKOGN1006376-N5	H	AH
10	MSKU8416005	V286-UKAKKOGN1006376-N6	I	AI
11	TCLU6297933	R708004	A	AA
12	TCLU6297933	R708005	B	AB
13	TCLU6297933	R708007	C	AC
14	TCLU6297933	R804021	D	AD
15	TCLU6297933	R804024	E	AE
16	TCLU6297933	R901013	F	AF
Upload format

 

[nahaku]

You could use a formula
=SUBSTITUTE(ADDRESS(1,COUNTIFS(J$2:J2,J2),4),1,"")

AMAZING :D Thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.