Chirag R Raval
Member
Dear Sir,
Attached an excel file with first original data sheet and 2nd sheet for mention requirement.
Database ,1 party's records spread in multiline lines based on year.
Require to convert that multiline record for single party in to 1 line (1 row)
As per screen shot below.
I manually take first step is insert 6 columns after last column(avg)
& copy heading's 6 cells as below
replace heading as next years data
now just move 6 cells of data under data to newly created 6 headings
I require party's record in single line due to I want to convert it as Access database as party wise single record so I can create party wise report as single block from Access
and also assign primary key to each unique party wise record .
This is just 173 records , just 173 parties there...but in excel its data spread by year
in 1034 lines .
You can see in my sample requirement sheet, converted 7 rows data for 1 party convert in single line as 52 columns
hope I described my requirement well .
Regards,
Chirag Raval
Attached an excel file with first original data sheet and 2nd sheet for mention requirement.
Database ,1 party's records spread in multiline lines based on year.
Require to convert that multiline record for single party in to 1 line (1 row)
As per screen shot below.
I manually take first step is insert 6 columns after last column(avg)
& copy heading's 6 cells as below
replace heading as next years data
now just move 6 cells of data under data to newly created 6 headings
I require party's record in single line due to I want to convert it as Access database as party wise single record so I can create party wise report as single block from Access
and also assign primary key to each unique party wise record .
This is just 173 records , just 173 parties there...but in excel its data spread by year
in 1034 lines .
You can see in my sample requirement sheet, converted 7 rows data for 1 party convert in single line as 52 columns
hope I described my requirement well .
Regards,
Chirag Raval
Attachments
Last edited: