Other presentation articles

[ehietland]

Who knows how I can change the presentation of articles data? We have a very big data file with this (some rows have more columns than others).

I refer to below for an example of the OLD data situation and the NEW situation presentation. Who knows the formulas or the things to do in Excel?

Hope you can help me. Thanks in advance.

Have a great day!

Old situation

CA112 30112 14201170 IA0021 59212958 AVA217A L610217 CAL15217 CS610 S0103 A19030 AES7108 SBO195 S510384 CST10195 3670 CS798 S9010 AES1210 SMG100 4,40501E+11 4,40501E+11 4,40501E+11 45013369 <colgroup><col><col><col><col span="3"><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

New situation

CA112 30112 CA112 14201170 CA112 IA0021 CA112 59212958 CA112 AVA217A CA112 L610217 CA112 CAL15217 CS610 S0103 CS610 A19030 CS610 AES7108 CS610 SBO195 CS610 S510384 CS610 CST10195 CS610 3670 CS798 S9010 CS798 AES1210 CS798 SMG100 CS798 4,40501E+11 CS798 4,40501E+11 CS798 4,40501E+11 CS798 45013369 <colgroup><col><col></colgroup><tbody> </tbody> <colgroup><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[Gerald Higgins]

Does every item have exactly 7 articles, or could this number vary ?

And do you need to do this just once, or regularly ?

 

[ehietland]

This number could vary unfortunately.

We need to do this for now only once.