Please help me for data arrangement as required.
ColA ColB ColC ColD
Ven_Code Ven_Name Narration Amount
Doc No.
101101 MAX INFOTECH
55001 Purchase-Mouse 10000.00
55002 Purchase-Keyboard 5000.00
101102 TECH HARDWARE
66001 Pur - SS Pipe 6mm 5000.00
Data should be arrange as follows after processing any macros
or other ms excel function.
ColA ColB ColC ColD ColE
Ven_Code Ven_Name Doc.No. Narration amount
101101 MAX INFOTECH 55001 Purchase-Mouse 10000.00
101101 MAX INFOTECH 55002 Purchase-Keyboard 5000.00
101102 TECH HARDWARE 66001 Pur - SS Pipe 6mm 5000.00

You are requested to please guide me for this. I am not knowing
macros. I am very thankful to you if you help me.

regards

kpsrajput