Forum Discussion
Solved
Add suffix to column in Power Query if duplicates
Hello! I have data that looks like this: I want to pivot it to look like this: I.e. "completed date"'s become the values for the rows of protocol id's and columns of milestones. ...
I think that's just telling you it doesn't know what [Data] is in that line.
Just from observation, it looks like the formula has been entered directly in the formula bar instead of in the Add Custom Column dialog. I'm sure it will get wrapped with a reference to the previous query step if you do that.
I think that's just telling you it doesn't know what [Data] is in that line.
Just from observation, it looks like the formula has been entered directly in the formula bar instead of in the Add Custom Column dialog. I'm sure it will get wrapped with a reference to the previous query step if you do that.
Lol. It was as simple as that, thank you.
