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...