Compile different column data

sanket_sk

New Member
Joined
Dec 27, 2016
Messages
26
Hi All,

We are collecting spare sale information using Microsoft, data is getting accumulated as Spare code 1 – Spare code 1 Qty , Spare code 2 – Spare code 2 Qty , Spare code 3 – Spare code 3 Qty , Spare code 4 – Spare code 4 Qty .

Now we want to compile the file as ASC name , spares list with Qty but since data is stored in separate columns (in some cases only 2 spare codes are filled instead of 6) , it is very difficult to compile the file.

Do we have any trick , Formula which will help us in compiling the data

Data format

Name of the ASCSpare Code 1Spare Code 1 QuantitySpare Code 2Spare Code 2 QuantitySpare Code 3Spare Code 3 QuantitySpare Code 4Spare Code 4 QuantitySpare Code 5Spare Code 5 QuantitySpare Code 6Spare Code 6 Quantity
Tatya Electronics3115209536811996510069596199651006959313115209536812

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>


Need in this format
NameSpare Code25-05-1926-05-1924-05-1927-05-19
Narendra Enterprises3115209536811
996510069596 1
996510069593 1

<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>


Sanket
 

Forum statistics

Threads
1,085,494
Messages
5,383,990
Members
401,869
Latest member
raikks

Some videos you may like

This Week's Hot Topics

Top