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
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 761"]
<colgroup><col><col><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD]CA112[/TD]
[TD]30112[/TD]
[TD]14201170[/TD]
[TD]IA0021[/TD]
[TD]59212958[/TD]
[TD]AVA217A[/TD]
[TD]L610217[/TD]
[TD]CAL15217[/TD]
[/TR]
[TR]
[TD]CS610[/TD]
[TD]S0103[/TD]
[TD]A19030[/TD]
[TD]AES7108[/TD]
[TD]SBO195[/TD]
[TD]S510384[/TD]
[TD]CST10195[/TD]
[TD]3670[/TD]
[/TR]
[TR]
[TD]CS798[/TD]
[TD]S9010[/TD]
[TD]AES1210[/TD]
[TD]SMG100[/TD]
[TD]4,40501E+11[/TD]
[TD]4,40501E+11[/TD]
[TD]4,40501E+11[/TD]
[TD]45013369[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

New situation
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 247"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 247"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]CA112[/TD]
[TD]30112[/TD]
[/TR]
[TR]
[TD]CA112[/TD]
[TD]14201170[/TD]
[/TR]
[TR]
[TD]CA112[/TD]
[TD]IA0021[/TD]
[/TR]
[TR]
[TD]CA112[/TD]
[TD]59212958[/TD]
[/TR]
[TR]
[TD]CA112[/TD]
[TD]AVA217A[/TD]
[/TR]
[TR]
[TD]CA112[/TD]
[TD]L610217[/TD]
[/TR]
[TR]
[TD]CA112[/TD]
[TD]CAL15217[/TD]
[/TR]
[TR]
[TD]CS610[/TD]
[TD]S0103[/TD]
[/TR]
[TR]
[TD]CS610[/TD]
[TD]A19030[/TD]
[/TR]
[TR]
[TD]CS610[/TD]
[TD]AES7108[/TD]
[/TR]
[TR]
[TD]CS610[/TD]
[TD]SBO195[/TD]
[/TR]
[TR]
[TD]CS610[/TD]
[TD]S510384[/TD]
[/TR]
[TR]
[TD]CS610[/TD]
[TD]CST10195[/TD]
[/TR]
[TR]
[TD]CS610[/TD]
[TD]3670[/TD]
[/TR]
[TR]
[TD]CS798[/TD]
[TD]S9010[/TD]
[/TR]
[TR]
[TD]CS798[/TD]
[TD]AES1210[/TD]
[/TR]
[TR]
[TD]CS798[/TD]
[TD]SMG100[/TD]
[/TR]
[TR]
[TD]CS798[/TD]
[TD]4,40501E+11[/TD]
[/TR]
[TR]
[TD]CS798[/TD]
[TD]4,40501E+11[/TD]
[/TR]
[TR]
[TD]CS798[/TD]
[TD]4,40501E+11[/TD]
[/TR]
[TR]
[TD]CS798[/TD]
[TD]45013369[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.