INDEX and OFFSET Formulas

K

Kiley

If I have a set of veritcal data for each employee, but each set of data
could range from 1 to 4 vertical values, is there a way to change the
following formulas to accomodate moving the data from horizontal to
vertical?:

=INDEX($A$2:$A$1690,1+(8*(ROWS(H$1:H1)-1)))
=OFFSET($G$2,ROW(A1)*8-8+COLUMN(R2)-18,)

Data Sample:
ID Data
275 Capitalize on Technical and Professional Know-How
275 Foster Teamwork
275 Value Others
933 Demonstrate Agility
933 Drive for Results
933 Team Leadership
933 Use Technical/Functional Expertise
658 Capitalize on Technical and Professional Know-How
658 Foster Teamwork
658 Manage Execution
1113 Demonstrate Drive & Commitment
1113 Leading Innovation
1113 Maximize Empowerment
147 Align with Strategy & Direction
147 Foster Teamwork
147 Manage for Results
1685 Analyze/Solve Problems
1685 Demonstrate Drive & Commitment
1685 Meet Customer Needs
880 Foster Teamwork
880 Manage for Results
880 Value Others
1130 Commit to Quality
1130 Develop Oneself
1130 Prepare Written Communication
227 Demonstrate Adaptability
227 Foster Open Communication
227 Innovate
267 Coach Others
267 Lead Boldly
267 Leading Change
253 Make Sound Decisions
253 Manage for Results
1521 Build Relationships
 

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

Top