# Looking for component suggestion **URL:** \ **Category:** CloverDX Platform\ **Created:** [January 19, 2015, 12:00am UTC](https://forum.cloverdx.com/t/looking-for-component-suggestion/1554 "2015-01-19T00:00:00Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![hapablap](https://avatars.discourse-cdn.com/v4/letter/h/e5b9ba/32.png) [@hapablap](https://forum.cloverdx.com/u/hapablap)\ **Post date:** [January 19, 2015, 12:00am UTC](https://forum.cloverdx.com/t/looking-for-component-suggestion/1554/1 "2015-01-19T00:00:00Z")
Hi, I’m fairly new to Clover and I’m looking for some help with choosing which component to do a certain transformation. All of the data is coming from a single excel file (one input) Sample data: ```auto 1|a|-|- 1|-|b|- 1|-|-|c 2|d|-|- 2|-|-|e 2|-|f|- 3|-|-|g 3|h|-|- 3|-|i|- ``` I am looking to merge these rows based on their row id (assume first column is row id) Desired output: ```auto 1|a|b|c 2|d|e|f 3|g|h|i ``` Any help is much appreciated. Cheers ---
**Author:** ![imriskal](https://avatars.discourse-cdn.com/v4/letter/i/b38774/32.png) [@imriskal](https://forum.cloverdx.com/u/imriskal)\ **Post date:** [January 20, 2015, 9:16am UTC](https://forum.cloverdx.com/t/looking-for-component-suggestion/1554/2 "2015-01-20T09:16:04Z")
Hi, You can use component [Denormalizer](http://doc.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/denormalizer.html). I think it is the one you are looking for. By the way, why your output does not look like the following? ```auto 1|a|b|c 2|d|f|e 3|h|i|g ``` Do you prefer the order of input records over field position? ---
**Author:** ![hapablap](https://avatars.discourse-cdn.com/v4/letter/h/e5b9ba/32.png) [@hapablap](https://forum.cloverdx.com/u/hapablap)\ **Post date:** [January 20, 2015, 8:43pm UTC](https://forum.cloverdx.com/t/looking-for-component-suggestion/1554/3 "2015-01-20T20:43:10Z")
Sorry I listed them in the wrong order, you are correct. I’ll look into denormalizer and respond if I have any questions. Thanks!