Aligning Rows and Columns with its Corresponding Values

[kochj1]

I am trying to align multiple jobs to a Master List.

For example:


Master List Job 1 Value Job 2 Value Job 3 Value
1 1 A
2 2 B 1 B 3 F
3 3 C 2 C 4 G
4 5 D 4 E 5 P
5

And I would like it to align like this

Master List Job 1 Value Job 2 Value Job 3 Value
1 1 A 1 B 1
2 2 B 2 C 2
3 3 C 3 3 F
4 4 4 E 4 G
5 5 D 5 5 P


Basically align the corresponding values to the Master list so I can compare everything to it.
Eventually I would like to delete the numbers under each job and have the values under them instead

Master List Job 1 Job 2 Job 3
1 A B
2 B C
3 C F
4 E G
5 D P