major data re-orginazation
 

I have a spreadsheet with approximately 6,000 lines. Each line represents
one participant. There are 231 columns. There are 7 quarters of information
with 22 columns for each quarter strung over the columns, along with some one
time info. The re-organized data needs to have each 22 column string in 7
rows. instead of strung together.

I'm at a loss for how to make this happen. I've tried using some simple
hlookups, this there is still a lot of formula correction for each partipant.

thanks

Andy

major data re-orginazation
 

my apologies, orginIzation

"AJB" wrote:

I have a spreadsheet with approximately 6,000 lines. Each line represents
one participant. There are 231 columns. There are 7 quarters of information
with 22 columns for each quarter strung over the columns, along with some one
time info. The re-organized data needs to have each 22 column string in 7
rows. instead of strung together.

I'm at a loss for how to make this happen. I've tried using some simple
hlookups, this there is still a lot of formula correction for each partipant.

thanks

Andy