major data re-orginazation

A

AJB

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rearranging and organizing data imbedded in rows 4
Piviot Table Data 1
How to organize data and use VLOOKUP 1
Pivot table headache 2
A Challenge 17
Sorting data 1
Inconsistent Sorting 17
How do I force a pivot column if there is no data? 5

Top