Forum Discussion
Combining 2 columns of names into one and matching other column info
Hello All, I have power automate triggering tasks and filling in a spreadsheet when certain emails come through. It's basically to track actions with strict timeframes. Power automate can fil...
Like Riny_van_Eekelen I suspect that waiting until the data is loaded into Excel in an unwanted format is a little late in the game to start making adjustments. That said Excel 365 is evolving to became a very different programming platform from traditional spreadsheets and techniques are becoming available that will allow you either to transform the data or simply use it as it stands.
PeterBartholomew1 , what's the reason to use formulas on the top of returned by Power Query table if you may add couple of more steps to already existing query?
- True, but the OP showed a picture of the Table but did not show the steps of the query that gave rise to it. Since a single formula proved sufficient to transform the data, I thought it to be worth showing, even if the underlying message is "If I were you, I wouldn't start from here".
