Hi everybody,
I am a bit new into the Xcell world, and I am breaking my head around the following topic, hope you can help me because I dont know which formula I have to use.
So I have a bunch of orders wich all have a different sub content (order 1 variant 1 has content A, B, C, D, E - Order 2 variant 2 has content E, A, F, X, etc).
I would like to group this subcontent so that every data has it own column. If an order does not have the specific head of the column, it can be left in blank. I put all the data from one cell in columns and I filtered it alphabeticly but i cant get it structured.
Example beginning raw data (content of order is in one cell)
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I divided the content of order from one cell to +/- 24 columns and have placed the individual data as heads. I manually made an example (untill $48).
I would like to know if there is a formula for this...
Thank you, much appreciated!
MRBCA
<tbody>
</tbody><colgroup><col><col><col span="2"><col span="2"><col span="3"><col><col><col span="2"><col><col span="3"><col span="12"><col><col><col><col><col></colgroup>
I am a bit new into the Xcell world, and I am breaking my head around the following topic, hope you can help me because I dont know which formula I have to use.
So I have a bunch of orders wich all have a different sub content (order 1 variant 1 has content A, B, C, D, E - Order 2 variant 2 has content E, A, F, X, etc).
I would like to group this subcontent so that every data has it own column. If an order does not have the specific head of the column, it can be left in blank. I put all the data from one cell in columns and I filtered it alphabeticly but i cant get it structured.
Example beginning raw data (content of order is in one cell)
| Order number | Model type | Content of order |
| 100001 | Version 1 | $21 $26 $48 $G3 C25 FTE P21 P24 PCI PG6 PK2 PNB PQS PSS PTC PW1 PXX PZ4 WAC WL3 X4A ZN4 |
| 100002 | Version 1 | $21 $26 $G3 $GE C25 FTE P1Z P21 P24 PB3 PBR PCI PDU PFK PG6 PK2 PNB PQS PSS PW1 PXX PZ4 RKG X4A ZN4 |
| 100003 | Version 1 | $21 $26 $G3 C25 FTE P1Z P21 P24 PB3 PBR PCI PDU PFK PG6 PK2 PNB PQS PSS PUK PW1 PXX PZ4 WL3 X4A ZN4 |
| 100004 | Version 2 | $21 $26 $G3 C25 FTE P21 P24 PB3 PCI PDS PFK PG6 PK2 PNB PSS PUK PW1 PXX PZ4 WAC WL3 X4A ZN4 |
| 100005 | Version 2 | $21 $26 $G3 C25 FTE P21 P24 PBR PCI PDS PFK PG6 PK2 PNB PQS PSS PTC PUK PW1 PXX PZ4 WAC WGR WL3 X4A ZN4 |
| 100006 | Version 2 | $23 $48 $BI $CE $G3 C25 FTE P23 PAD PG6 PK2 PML PSP PSS PTC PW1 PXX WGR WH2 X4A ZB8 |
| 100007 | Version 2 | $23 $48 $CE $G3 4L2 C25 FGU P23 PCO PK2 PML PXX WH2 X4A ZB8 |
| 100008 | Version 2 | $23 $48 $CE $G3 4L2 C25 FGU P23 PK2 PML PW1 PXX WH2 X4A ZB8 |
| 100009 | Version 2 | $23 $48 $CE $G3 C25 FGU P23 PCO PG5 PK2 PML PSS PUB PXX WH2 X4A ZB8 |
| 100019 | Version 3 | $23 $CE $G3 4L2 C25 FGU P23 PCO PK2 PML PW1 PXX WH2 X4A ZB8 |
| 100020 | Version 3 | $23 $CE $G3 4L2 C25 FTE P23 PK2 PML PXX WH2 X4A ZB8 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I divided the content of order from one cell to +/- 24 columns and have placed the individual data as heads. I manually made an example (untill $48).
I would like to know if there is a formula for this...
Thank you, much appreciated!
MRBCA
| Order number | Model type | $21 | $23 | $24 | $25 | $26 | $27 | $28 | $48 | Etcetera | Etcetera | Etcetera | |||||||||||||||||||||
| 100001 | Version 1 | $21 | $26 | $48 | $G3 | C25 | FTE | P21 | P24 | PCI | PG6 | PK2 | PNB | PQS | PSS | PTC | PW1 | PXX | PZ4 | WAC | WL3 | X4A | ZN4 | ||||||||||
| 100002 | Version 1 | $21 | $26 | $G3 | $GE | C25 | FTE | P1Z | P21 | P24 | PB3 | PBR | PCI | PDU | PFK | PG6 | PK2 | PNB | PQS | PSS | PW1 | PXX | PZ4 | RKG | X4A | ZN4 | |||||||
| 100003 | Version 1 | $21 | $26 | $G3 | C25 | FTE | P1Z | P21 | P24 | PB3 | PBR | PCI | PDU | PFK | PG6 | PK2 | PNB | PQS | PSS | PUK | PW1 | PXX | PZ4 | WL3 | X4A | ZN4 | |||||||
| 100004 | Version 2 | $21 | $26 | $G3 | C25 | FTE | P21 | P24 | PB3 | PCI | PDS | PFK | PG6 | PK2 | PNB | PSS | PUK | PW1 | PXX | PZ4 | WAC | WL3 | X4A | ZN4 | |||||||||
| 100005 | Version 2 | $21 | $26 | $G3 | C25 | FTE | P21 | P24 | PBR | PCI | PDS | PFK | PG6 | PK2 | PNB | PQS | PSS | PTC | PUK | PW1 | PXX | PZ4 | WAC | WGR | WL3 | X4A | ZN4 | ||||||
| 100006 | Version 2 | $23 | $48 | $BI | $CE | $G3 | C25 | FTE | P23 | PAD | PG6 | PK2 | PML | PSP | PSS | PTC | PW1 | PXX | WGR | WH2 | X4A | ZB8 | |||||||||||
| 100007 | Version 2 | $23 | $48 | $CE | $G3 | 4L2 | C25 | FGU | P23 | PCO | PK2 | PML | PXX | WH2 | X4A | ZB8 | |||||||||||||||||
| 100008 | Version 2 | $23 | $48 | $CE | $G3 | 4L2 | C25 | FGU | P23 | PK2 | PML | PW1 | PXX | WH2 | X4A | ZB8 | |||||||||||||||||
| 100009 | Version 2 | $23 | $48 | $CE | $G3 | C25 | FGU | P23 | PCO | PG5 | PK2 | PML | PSS | PUB | PXX | WH2 | X4A | ZB8 | |||||||||||||||
| 100019 | Version 3 | $23 | $CE | $G3 | 4L2 | C25 | FGU | P23 | PCO | PK2 | PML | PW1 | PXX | WH2 | X4A | ZB8 |
<tbody>
</tbody><colgroup><col><col><col span="2"><col span="2"><col span="3"><col><col><col span="2"><col><col span="3"><col span="12"><col><col><col><col><col></colgroup>
