Formula to rearrange table

[jimgun]

help me
i have this table

[TABLE="class: cms_table, width: 553"]
<tbody>[TR]
[TD]Nama Barang[/TD]
[TD] Jual/dos[/TD]
[TD] Jual/bos[/TD]
[TD] Jual/ikat[/TD]
[TD] Jual Eceran[/TD]
[/TR]
[TR]
[TD]Sarimi Ayam Bawang[/TD]
[TD="align: right"]76000[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]Sarimi Ayam Merah / Baso[/TD]
[TD="align: right"]77000[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]Sedap Ayam Special Pok Pok[/TD]
[TD="align: right"]76000[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]Sedap Cup Godog[/TD]
[TD="align: right"]42000[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3500[/TD]
[/TR]
[TR]
[TD]Bijag (T)[/TD]
[TD][/TD]
[TD="align: right"]43500[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Burung Dara Besar[/TD]
[TD][/TD]
[TD="align: right"]34000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Burung Dara Renteng[/TD]
[TD="align: right"]58500[/TD]
[TD][/TD]
[TD][/TD]
[TD] 10000/H
[/TD]
[/TR]
</tbody>[/TABLE]



I WANT TO IMPORT INTO THIS TABLE
[TABLE="class: cms_table"]
<tbody>[TR]
[TD="class: cms_table_xl68"]NAMA ITEM[/TD]
[TD="class: cms_table_xl69, width: 109"] HARGA JUAL [/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Sarimi Ayam Bawang[/TD]
[TD="class: cms_table_xl71"] 2,000[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Sarimi Ayam Bawang[/TD]
[TD="class: cms_table_xl71"] 76,000[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Sarimi Ayam Merah / Baso[/TD]
[TD="class: cms_table_xl71"] 2,000[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Sarimi Ayam Merah / Baso[/TD]
[TD="class: cms_table_xl71"] 77,000[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Sedap Ayam Special Pok Pok[/TD]
[TD="class: cms_table_xl71"] 2,000[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Sedap Ayam Special Pok Pok[/TD]
[TD="class: cms_table_xl71"] 76,000 [/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Sedap Cup Godog[/TD]
[TD="class: cms_table_xl71"] 3,500[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Sedap Cup Godog[/TD]
[TD="class: cms_table_xl71"] 42,000[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Bijag (T)[/TD]
[TD="class: cms_table_xl67"] 43,500[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]Burung Dara Besar[/TD]
[TD="class: cms_table_xl67"] 34,000 [/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Burung Dara Renteng[/TD]
[TD="class: cms_table_xl71"] 10,000[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl70"]Burung Dara Renteng[/TD]
[TD="class: cms_table_xl71"] 58,500
[/TD]
[/TR]
</tbody>[/TABLE]


Can someone help me with formula that can be used to import???

 

[jimgun]

admin help me please...

 

[jimgun]

somebody help me please...

 

[AliGW]

I think you need to exercise a little bit of patience. It is only an hour and a half since you started this thread and by bumping it, you have removed it from the zero reply list, which many members use to identify posts that need a response. Are you aware that those who help here are unpaid volunteers from all over the world who help out in their free time? As soon as someone who can help you comes along, they will respond, but that person might still be asleep at the moment on the other side of the globe.

 

[Macropod]

Can someone help me with formula that can be used to import???

Probably not. A macro would most likely be required. A forum search would probably turn up such a macro that you could adapt. For example: https://www.mrexcel.com/forum/excel-questions/644481-creating-macro-rearrange-data.html

If you can't find or adapt that macro or another one, please be patient - as Ali said. Some of us have things other than answering impatient peoples' posts; things such as working for a living, eating, sleeping, etc., etc.

 

[jimgun]

Probably not. A macro would most likely be required. A forum search would probably turn up such a macro that you could adapt. For example: https://www.mrexcel.com/forum/excel-questions/644481-creating-macro-rearrange-data.html

If you can't find or adapt that macro or another one, please be patient - as Ali said. Some of us have things other than answering impatient peoples' posts; things such as working for a living, eating, sleeping, etc., etc.

thanks for your help

 

[jimgun]

i have the new table with this can soemone help me for making macro vba excel to rearrange....?????

<tbody>
[TD="class: xl63"]NAMA BARANG[/TD]
[TD="class: xl66, width: 85"]HARGA BELI[/TD]
[TD="class: xl64, width: 117"]DOS[/TD]
[TD="class: xl65, width: 64"]BOS[/TD]
[TD="class: xl64, width: 64"]IKAT[/TD]
[TD="class: xl65, width: 64"]PCS[/TD]

[TD="class: xl65"]Bihun Beras Superior[/TD]
[TD="class: xl66, align: right"]54000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65, align: right"]56000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65, align: right"]3000[/TD]

[TD="class: xl63"]Bihun jagung Jangkar Loss 2 kg[/TD]
[TD="class: xl66, align: right"]20000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]22000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]Bijag (B)[/TD]
[TD="class: xl66, align: right"]52000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]56000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]Bijag (K)[/TD]
[TD="class: xl66, align: right"]26465[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]27500[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]Bijag (T)[/TD]
[TD="class: xl66, align: right"]42708[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]43500[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]Burung Dara Besar[/TD]
[TD="class: xl66, align: right"]32500[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]34000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]Burung Dara Renteng[/TD]
[TD="class: xl66, align: right"]57000[/TD]
[TD="class: xl63, align: right"]58500[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]10000[/TD]

[TD="class: xl63"]Burung Doro Mas[/TD]
[TD="class: xl66, align: right"]22500[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]23500[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]Burung Doro Pipih[/TD]
[TD="class: xl66, align: right"]46000[/TD]
[TD="class: xl63, align: right"]48000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]2500[/TD]

[TD="class: xl63"]Burung Doroku[/TD]
[TD="class: xl66, align: right"]60000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]62000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]7000[/TD]

[TD="class: xl63"]Mie Tali menara[/TD]
[TD="class: xl66, align: right"]17000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]18500[/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]Mie Tali ljo Superior[/TD]
[TD="class: xl66, align: right"]27500[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]28000[/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]Mie tali Menara besar[/TD]
[TD="class: xl66, align: right"]21000[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]22500[/TD]
[TD="class: xl63"][/TD]

</tbody>

i want to rearrange to this

<tbody>
[TD="class: xl65"]NAMA BARANG[/TD]
[TD="class: xl65, width: 85"]SATUAN[/TD]
[TD="class: xl68, width: 117"]HARGA BELI[/TD]
[TD="class: xl65, width: 64"]HARGA JUAL[/TD]

[TD="class: xl67"]Bihun Beras Superior[/TD]
[TD="class: xl67"]PCS[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67, align: right"]3000[/TD]

[TD="class: xl67"]Bihun Beras Superior[/TD]
[TD="class: xl67"]BOS[/TD]
[TD="class: xl68, align: right"]54000[/TD]
[TD="class: xl67, align: right"]56000[/TD]

[TD="class: xl65"]Bihun jagung Jangkar Loss 2 kg[/TD]
[TD="class: xl66"]BOS[/TD]
[TD="class: xl68, align: right"]20000[/TD]
[TD="class: xl65, align: right"]22000
[/TD]

[TD="class: xl65"]Bijag (B)[/TD]
[TD="class: xl66"]BOS[/TD]
[TD="class: xl68, align: right"]52000[/TD]
[TD="class: xl65, align: right"]56000
[/TD]

[TD="class: xl65"]Bijag (K)[/TD]
[TD="class: xl66"]BOS[/TD]
[TD="class: xl68, align: right"]26465[/TD]
[TD="class: xl65, align: right"]27500[/TD]

[TD="class: xl65"]Bijag (T)[/TD]
[TD="class: xl66"]BOS[/TD]
[TD="class: xl68, align: right"]42708[/TD]
[TD="class: xl65, align: right"]43500[/TD]

[TD="class: xl65"]Burung Dara Besar[/TD]
[TD="class: xl66"]BOS[/TD]
[TD="class: xl68, align: right"]32500[/TD]
[TD="class: xl65, align: right"]34000[/TD]

[TD="class: xl65"]Burung Dara Renteng[/TD]
[TD="class: xl66"]PCS[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69, align: right"]10000
[/TD]

[TD="class: xl65"]Burung Dara Renteng[/TD]
[TD="class: xl70"]DOS[/TD]
[TD="class: xl68, align: right"]57000[/TD]
[TD="class: xl65, align: right"]58500[/TD]

[TD="class: xl65"]Burung Doro Mas[/TD]
[TD="class: xl66"]BOS[/TD]
[TD="class: xl68, align: right"]22500[/TD]
[TD="class: xl65, align: right"]23500[/TD]

[TD="class: xl65"]Burung Doro Pipih[/TD]
[TD="class: xl66"]PCS[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl65, align: right"]2500
[/TD]

[TD="class: xl65"]Burung Doro Pipih[/TD]
[TD="class: xl70"]DOS[/TD]
[TD="class: xl68, align: right"]46000[/TD]
[TD="class: xl65, align: right"]48000[/TD]

[TD="class: xl65"]Burung Doroku[/TD]
[TD="class: xl66"]PAK[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl65, align: right"]7000[/TD]

[TD="class: xl65"]Burung Doroku[/TD]
[TD="class: xl66"]BOS[/TD]
[TD="class: xl68, align: right"]60000[/TD]
[TD="class: xl65, align: right"]62000[/TD]

[TD="class: xl65"]Mie Tali menara[/TD]
[TD="class: xl66"]IKAT[/TD]
[TD="class: xl68, align: right"]17000[/TD]
[TD="class: xl65, align: right"]18500[/TD]

[TD="class: xl65"]Mie Tali ljo Superior[/TD]
[TD="class: xl66"]IKAT[/TD]
[TD="class: xl68, align: right"]27500[/TD]
[TD="class: xl65, align: right"]28000[/TD]

[TD="class: xl65"]Mie tali Menara besar[/TD]
[TD="class: xl66"]IKAT[/TD]
[TD="class: xl68, align: right"]21000[/TD]
[TD="class: xl65, align: right"]22500[/TD]

</tbody>