Forum Discussion
Combine and Transform Data
I am attempting to stack columns of text data from multiple excel files. When I attempt to combine, the power query limits my characters to ~250 which ends up truncating some of my data. This is both...
if I am not missing something, I have experienced an opposite situation: it is excel which has a limit of 255 characters per cell, while power query allows longer texts
So what exactly is the problem you encounter?