Arranging row of data into 3X3 or 2X2 box in another sheet

[sampahmel]

Hello,

I'm looking to arrange a row of data in Sheet 2 into 3 by 3 (3X3) box or 2 by 2 (2X2) box found in Sheet 1.

Can anyone show me how to do that in the attached spreadsheet?

Thank you.

 

[Somendra Misra]

Hi sampahmel,

See the file.

Regards,

 

[pecoflyer]

Cross post http://www.excelforum.com/excel-general/1021249-arranging-row-of-data-into-3x3-or-2x2-box-in-another-sheet.html

 

[pecoflyer]

New cross post http://www.excelguru.ca/forums/showthread.php?3205-Arranging-row-of-data-in-3X3-or-2X2&s=3574222d4048082836ba3d06a060547a