Hello Everyone,
I have 4 different files (one column in each) that I'm trying to combine into 1 file with four columns. Having issues trying to get the columns to format properly. I have tried the following:
paste file1 file2 file3 file4 | column -s $'\t' -t > results.txt
paste file1 file2 file3 file4 | sed 's/\t/\0\t/g' | column -s $'\t' -t > results.txt
With both of those options it seems like the empty cells keep being ignored. Therefore, all of the data on the right that have nothing before it (on the left) keep getting moved to the first column; i.e. something in column 3 that has no data in the same row in column 1 or 2 gets moved to column 1.
Does anyone have any ideas on how I could format this correctly?
Looking to get the data (few hundred lines) into one file to distribute it easily.