How to convert Multiple Row Data into Single Column Data using Excel

Sometimes we need to convert large amount of data collected from experiments to convert into single column, so that we can analyze it properly. Here's how you can do it using Excel.

How to convert Multiple Row Data into Single Column Data using Excel

Use this formula of Excel and change the end cell number.

=INDEX($A$1:$H$125,1+INT((ROW(A1)-1)/COLUMNS($A$1:$H$125)),MOD(ROW(A1)-1+COLUMNS($A$1:$H$125),COLUMNS($A$1:$H$125))+1)

Copy Formula
Trying to understand Physics in a Simple way.

Post a Comment

© My Physics. All rights reserved. Developed by Jago Desain