concatenate with specific amount of characters?

Is there a way to combine functions in excel to create something like: Concatenate(X1,X2,X3,X4) with all X1 to X4 with a (different) defined length?
So, if X1 only has 3 characters it should still be seen as e.g. 6 characters. (so 3 spaces are added at the end of X1)
to give an example: concatenate(X1;X2;X3;X4) and length 6;6;8;5
with X1=123.;X2=123;X3=123;X4=123 should result in:
123___123___123_____123__ with _ for the spaces

The formula does exactly what I asked for, but the results are not what I hoped for.

I have two tabs in my excel that I want to combine in one print, both containing up to 3000 rows.

Tab 1 contains positions (posistionnumber, name, quantity, price etc) and below several rows off calculation.
Tab 2 contains the same positions with several rows of explanations

Both tabs have several columns.

I got the request to have a print made of all the positions with: position, explanation and the calculation, then the next position.

My idea was to use the formula above so only one column with data would be left per tab, the problem is though that the characters don't have the same size and the print ends in a bit of a mess. Any other idea to make a combined print?