Transposing data from consecutive rows into non-consecutive rows

E

econ

I have spreadsheet data that extends across more than 24 columns. I have
about 300 rows of data. I want to be able to rearrange this information so
that it displays on a screen. To do this I have set up a "record" that has
headers in columns A to J (row1) then corresponding data in row2, a further
set of headers in row3 columns A to J, and its corresponding data in row4,
and so on. I am trying to set up a formula using simply "=" or using "OFFSET"
but the problem is that in the original sheet the record data advances in
consecutive rows, where in the display sheet the records advance about every
8 rows.

Any suggestions on how I can do this?
 

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

Searching for non-consecutive text 3
Copy addition formula of non-consecutive horizontal cells 2
Deleting blank rows 5
Cell data entering slow! 0
Formula from consecutive rows to alternate rows? 2
Linking Rows Between Sheets When Sorting 1
Count max consecutive cells 2
Referencing cells in consecutive rows 2

Top