aa2

Hi I'm trying to concatenate two columns if one of the columns is not -1 and I'm running into some difficulty. I came up with this formula but it's not being accepted - =IF(AA<>-1,CONCATENATE(A2,AA2),-1)) If column AA is -1, I'd like the concatenate column to remain -1 but if it's not -1, I'd...

Hey community! I am getting deeper and deeper into the world of Power Query and Power Pivot. It brings a lot of potential and makes my job a lot easier. Currently I am facing the following problem:I have the following two tables in Power Query, which I want to load in Power Pivot and present...

Hello everyone, I have a find place problem I do not have the skills to solve I want to replace all the commas + space ", " with a pipe | I have some column data in a sheet called Have that looks like the following, where "one" is the column header <tbody> one aa2 aa3, aa1, aa5 aa1...

Sorry if the title isn't descriptive I honestly had no clue how to quickly say what I'm working on.Hello, thanks very much in advanced for the help. Basically I have a long list with two columns, the first column has a word and the second a string of numbers. I would like to automatically...