Spreadsheet: 218576d1362501988-aligning-across-multiple-columns-aligning-example1
Sheet: Sheet1

Code | Lot | Name | genealogy | res_code | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
SIN10F03-4851/BLK |  | CH10F03-4851/BLK | +1.5.M |  | SIN10F03-4851/BLK
SIN11F03-4441/005 |  | CH11F03-4441/005 | *.3.5 |  | SIN11F03-4441/005 | SDF12F04-6532/001
SMX10F08-6203/059 |  | CLX38103 | Ms2A5B5H |  |  |  |  |  |  | SMX10F08-6203/059
SOH03F06-8474/BLK |  | DRD 8157 | Ms14B1AMs | 4L505 |  |  |  | SOH03F06-8474/BLK
SDF04F09-4806/BLK | 04D4806-SB | DRD 8157 | Ms14B2C1Ms | 5L510 |  |  |  |  |  |  | SDF04F09-4806/BLK
SOH03F06-8437/BK1 |  | DRD 8157 | Ms3D2AMs |  |  |  |  | SOH03F06-8437/BK1
SDF07F07-4073/BK2 |  | DRD 8157 | [NAME] | 6L526 |  |  |  |  | SDF07F07-4073/BK2
SMX09F06-4803/002 |  | DT090 | Ms4A2B |  |  |  |  | SMX09F06-4803/002
IIB12F06-4245/001 |  | [NAME] | Ms21G1A |  |  |  |  | IIB12F06-4245/001
IIB12F06-4248/001 |  | [NAME] | Ms24G2A |  |  |  |  | IIB12F06-4248/001
IIB12F06-4239/001 |  | [NAME] | Ms8FMS1 |  |  |  |  | IIB12F06-4239/001
SDF07F08-4517/BLK |  | FDC004 | Ms27C1AMs | 8L537 |  |  |  |  |  | SDF07F08-4517/BLK
SDF12F10-6401/BK1 |  | FDC342 | 3A2A1Ms.M1 |  |  |  |  |  |  |  |  | SDF12F10-6401/BK1
FDF11F10-9771/BK1 |  | FDC359 | 4A1AMS4MSMS |  |  |  |  |  |  |  |  | FDF11F10-9771/BK1
FDF12F04-9919/002 |  | FDC487 | Ms2.2 |  |  | FDF12F04-9919/002
FDF11F06-9630/001 |  | FTC09623 | MS22A1A |  |  |  |  | FDF11F06-9630/001
SDF10F11-6706/BK2 |  | HMX6858 | Ms10B1A4Ms6MsBS | 0L545 |  |  |  |  |  |  |  |  | SDF10F11-6706/BK2
What I want is for it to end up like this:
Code | Lot | Name | genealogy | res_code | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
SIN10F03-4851/BLK |  | CH10F03-4851/BLK | +1.5.M |  |  |  |  |  |  |  |  |  | SIN10F03-4851/BLK
SIN11F03-4441/005 |  | CH11F03-4441/005 | *.3.5 |  |  |  |  |  |  |  |  | SIN11F03-4441/005 | SDF12F04-6532/001
SMX10F08-6203/059 |  | CLX38103 | Ms2A5B5H |  |  |  |  |  |  |  |  |  | SMX10F08-6203/059
SOH03F06-8474/BLK |  | DRD 8157 | Ms14B1AMs | 4L505 |  |  |  |  |  |  |  |  | SOH03F06-8474/BLK
SDF04F09-4806/BLK | 04D4806-SB | DRD 8157 | Ms14B2C1Ms | 5L510 |  |  |  |  |  |  |  |  | SDF04F09-4806/BLK
SOH03F06-8437/BK1 |  | DRD 8157 | Ms3D2AMs |  |  |  |  |  |  |  |  |  | SOH03F06-8437/BK1
SDF07F07-4073/BK2 |  | DRD 8157 | [NAME] | 6L526 |  |  |  |  |  |  |  |  | SDF07F07-4073/BK2
SMX09F06-4803/002 |  | DT090 | Ms4A2B |  |  |  |  |  |  |  |  |  | SMX09F06-4803/002
IIB12F06-4245/001 |  | [NAME] | Ms21G1A |  |  |  |  |  |  |  |  |  | IIB12F06-4245/001
IIB12F06-4248/001 |  | [NAME] | Ms24G2A |  |  |  |  |  |  |  |  |  | IIB12F06-4248/001
IIB12F06-4239/001 |  | [NAME] | Ms8FMS1 |  |  |  |  |  |  |  |  |  | IIB12F06-4239/001
SDF07F08-4517/BLK |  | FDC004 | Ms27C1AMs | 8L537 |  |  |  |  |  |  |  |  | SDF07F08-4517/BLK
SDF12F10-6401/BK1 |  | FDC342 | 3A2A1Ms.M1 |  |  |  |  |  |  |  |  |  | SDF12F10-6401/BK1
FDF11F10-9771/BK1 |  | FDC359 | 4A1AMS4MSMS |  |  |  |  |  |  |  |  |  | FDF11F10-9771/BK1
FDF12F04-9919/002 |  | FDC487 | Ms2.2 |  |  |  |  |  |  |  |  |  | FDF12F04-9919/002
FDF11F06-9630/001 |  | FTC09623 | MS22A1A |  |  |  |  |  |  |  |  |  | FDF11F06-9630/001
SDF10F11-6706/BK2 |  | HMX6858 | Ms10B1A4Ms6MsBS | 0L545 |  |  |  |  |  |  |  |  | SDF10F11-6706/BK2