want to creat new list from diffrent data

all my gurus pls help

I am attaching the file please go through the file this is the only sample file in this format i have 200000 records in same fields as it showing in the file. and same gap


Now i want to make a new sheet where party name,party code, residence phone no in one row hope you understand my probleme, please help me to solve the prob