How to insert rows in transposed data table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All,
I attempted to add rows in a pre-set transposed data table and was unable.
The message shows "you cannot change part of array". For those who have
answers, please kindly forward your advise to me, truly appreciate your help!
Regards,
Mike
(e-mail address removed)
 
Am I right that you have used a matrix formula like: =TRANSPOSE(range)?
If so, try instead =INDEX($A$1:$D$10,COLUMN($A$1),ROW($A$1)) if you have your data in A1:D10.

Regards
Hans
 
Sorry, the formula should have been:
=INDEX($A$1:$D$10,COLUMN(A1),ROW(A1))

Hans
 
You must log in or register to reply here.

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

Transpose data and retain links to original data 2
Inserting blank rows for missing data in order to transpose 3
How to copy a row with transposing to a column retaining links to input cells? 2
Transposing data in Access 2007 Query 1
Transposing multiple rows to multiple columns 18
How to transpose data (Row to column) without losing the cell link 3
Transpose Access Table / Query 5
Transpose Rows to Columns based on Like Data 2

Back
Top