# Data cleaning for data spread over multiple rows and columns

**URL:** <https://community.easymorph.com/t/data-cleaning-for-data-spread-over-multiple-rows-and-columns/1499>\
**Category:** General Q&A\
**Created:** [December 18, 2019, 12:34pm UTC](https://community.easymorph.com/t/data-cleaning-for-data-spread-over-multiple-rows-and-columns/1499 "2019-12-18T12:34:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vaibhavtandon87](https://community.easymorph.com/user_avatar/community.easymorph.com/vaibhavtandon87/32/1494_2.png) [@vaibhavtandon87](https://community.easymorph.com/u/vaibhavtandon87)\
**Post date:** [December 18, 2019, 12:34pm UTC](https://community.easymorph.com/t/data-cleaning-for-data-spread-over-multiple-rows-and-columns/1499/1 "2019-12-18T12:34:28Z")

</div>

Hi community,

Not sure if somebody has already raised this query before as could not find anything basis search i used.

So a lot of times I receive data in multiple files that is symmetrical , there would be data in first 4 columns spread over 5 rows and then 10 rows below there would be 5X5 data. there would be another data 5 columns away.

Is there any way to clean up such data and create symmetrical data?

I am attaching files for reference[separateddata test.morph](https://community.easymorph.com/uploads/short-url/yi222IrAXg39hvK2TWVXIUOkPMH.morph) (3.1 KB) [separateddata test.xlsx](https://community.easymorph.com/uploads/short-url/maqfxbPuA2qHlQAR17Ghv5Z0T5f.xlsx) (8.2 KB)

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [December 18, 2019, 1:09pm UTC](https://community.easymorph.com/t/data-cleaning-for-data-spread-over-multiple-rows-and-columns/1499/2 "2019-12-18T13:09:21Z")

</div>

In your example, you can derive 3 tables and then process each block of data points in respective derived table. See example below:

[excel-cropping.morph](https://community.easymorph.com/uploads/short-url/kgmVTEHcl0CE7Yep5uzuGW1HLKc.morph) (5.8 KB)

 ![image](https://community.easymorph.com/uploads/default/original/2X/2/27a86a672ddb5356010809adb1b4fff50f396d34.png)
