Forum Discussion
Custom index assignment
I have a table with four columns : ID, Email, Phone 1 and Phone 2 columns. The Ids are unique for each entry. I need to assign a unique index to every entry, but the entries with same information need to have the same index. Same information can be found if an email is the same, a phone 1 or phone 2 are the same or a phone 2 is same with a phone 1 and the other way around. Indices will be also assigned to the entries that do not have connections. I need to perform this in Power Query.
3 Replies
biwarrior93 Can you provide sample data? The basic process I see for this would be to essentially get this in a form where you could do a "Group By", assign an Index and then expand it back out.
Something like that below. I want the index to be presented this way.
