Forum Discussion
concatenate a numeric column with text power query
I want to make a new column in power query, and want to contanate a numeric column with extra text. I get an error when I try: = Table.AddColumn(#"Added Custom1", "Custom.1", each Text.Combine({"...
Thanks for the reply. Actually, "Status" is free text. The pivoted columns are all numeric, and after pivoting becomes fields called 1,2,3...
It also works with free text.
Ninter