Transform matrix into a row of numbers

Welcome to the forum.

Pardon me if this is incorrect, but this sounds much like a homework problem and we don't solve those for students, but rather just provide general direction. So with that in mind, you can solve this by using an Index function with Row() and Column() as arguments pretty easily. No need for a macro.

If this is for work or another use, please let us know and accept my apologies.