Unique, Sequential, Alpha-Numeric Number Generation for Projects

Alansidman · #2 08-03-2024, 03:49 PM

Using Power Query, here is the Mcode. If you add data to the source table and click on Refresh All on the Data Tab, it will automatically update the output. Try it on my sample attached.

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Character Transition" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"0".."9"}, c), {"0".."9"}), {"Column1.1", "Column1.2"}),
    #"Sorted Rows" = Table.Sort(#"Split Column by Character Transition",{{"Column1.1", Order.Ascending}, {"Column1.2", Order.Ascending}}),
    #"Merged Columns" = Table.CombineColumns(#"Sorted Rows",{"Column1.1", "Column1.2"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged")
in
    #"Merged Columns"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Some alpha/numeric data missing when I run MS Query	Baldeagle	Excel Programming	1	01-28-2015 01:00 PM
first character NOT Alpha numeric or Tilde (~) delete.	ksridh	Word VBA	5	03-17-2014 12:45 AM
Labeling sequential forms with a unique number	krau0231	Word	1	10-18-2012 03:33 PM
How to do an alpha numeric Sort By?	Opul3nce	Excel	1	10-15-2012 11:11 PM
[How To] Generate Alpha Numeric Values in Excel 2010	stnicholas81	Excel	1	07-25-2011 01:31 AM