data import files transposing lines into one line per file instead of one line with all files

data import files transposing lines into one line per file instead of one line with all files - help

Hi, thanks for looking. I have many files where each file contains any number of lines - goal is to import all files where each file's content is transposed into one row, where each line in each file is a column in each row.

I can get this done my combining all the files into one column - then copying each file's lines, using paste special and transpose in a different tab - this works fine and takes a long time to do with possible errors.

I've tried all kinds of combinations and online recommendations - nothing is clicking yet. The closest I've gotten is that all files are imported into one row. Ideas are very appreciated. Thank you.