filestr = fileread('YourFile.txt');
filebyline = regexp(filestr, '\n', 'split');
filebyline( cellfun(@isempty,filebyline) ) = [];
filebyfield = regexp(filebyline, '\|', 'split');
numfields = cellfun(@length, filebyfield);
maxfields = max(numfields);
fieldpattern = repmat({[]}, 1, maxfields);
firstN = @(S,N) S(1:N);
filebyfield = cellfun(@(S) firstN([S,fieldpattern], maxfields), filebyfield, 'Uniform', 0);
fieldarray = vertcat(filebyfield{:});
Now to be consistent with your diagram, we have to convert to numeric not column by column but rather item by item: your row #8 column #3 is converted to a number even though it is the only one in the column that is converted. This is unusual and would typically lead to problems further down the road, but it is what you said you wanted.
numarray = str2double(fieldarray);
outarray = num2cell(numarray);
conv_failed = isnan(numarray);
outarray(conv_failed) = fieldarray(conv_failed);
The first part of this code, leading up to the creation of "fieldarray", can be made much much compact if the maximum number of fields per line is known in advance.
fields_per_line = 73;
fmt = repmat('%s',1,fields_per_line);
fid = fopen('YourTextFile', 'rt');
filebycolumn = textscan(fid, fmt, 'Delimiter', '|');
fclose(fid);
fieldarray = horzcat(filebycolumn{:});