TOROW function

[dancer5]

I'm using the TOROW function to transpose my array into one row and it works exactly as I need. The problem is that I need to values now in each cell and not the formula. Copy/Paste as values isn't working, it only pastes the first cell.
Any ideas on how to solve? I'm transposing 100 rows with 13 columns each into one long row.

 

[Fluff]

Select the cell with the formula then Ctrl A followed by Ctrl C & then you can paste as values.

 

[dancer5]

That only pastes the value for the cell that had the formula not the whole row. The row has up to 1300 cells, so I don't know if that is impacting it, but even a row with 156 cells is not pasting as values except that first cell.

 

[Fluff]

In that case it sounds as though you did not do what I suggested. As long as you select the entire spill range, then it should work.

 

[dancer5]

I discovered the issue, my reference array was in another workbook. Once I copy/pasted the data into the same sheet, I could copy/paste the value of the TOROW.

 

[Fluff]

Glad you sorted it & thanks for the feedback.