Extract text from matrix to single column

[QuentinLDN]

Hi,

I have a matrix with a large amount of columns (900) and rows (500).

I would like to extract only the text from this matrix (not the empty cells or those referring as "" in case of formula such as IFERROR) and input the text into a single column.

I found a solution to convert the matrix into a single column but due to the large amount of iterations, Excel could not perform such an operation.

I have attached an example for better understanding.

Thanks in advance!

[AliGW]

Welcome to the forum.

PowerQuery can help you here (it is part of Excel 2016).

M Code:

Please Login or Register  to view this content.

Tghere are links in my signature line to more information about using PQ.