# Data exported from Dynamo to Excel **URL:** \ **Category:** Revit\ **Tags:** excel\ **Created:** [September 11, 2020, 9:23pm UTC](https://forum.dynamobim.com/t/data-exported-from-dynamo-to-excel/55072 "2020-09-11T21:23:59Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![jarod.tulanowski](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jarod.tulanowski/32/83235_2.png) [@jarod.tulanowski](https://forum.dynamobim.com/u/jarod.tulanowski)\ **Post date:** [September 11, 2020, 9:23pm UTC](https://forum.dynamobim.com/t/data-exported-from-dynamo-to-excel/55072/1 "2020-09-11T21:23:59Z")
Has anyone formated the raw date exported out of Dynamo to Excel. I suck at Excel and just want pointed in the right direction. I have A revision schedule exported and want to combine some of the like formatting. I am sure I am in the wrong place to ask this Revision, Sheet number, Sheet Name. then all of the comments down the same row FE - R1 A1.0 Floor Plan - Comment 1 \_\_\_\_\_\_\_\_\_\_\_\_\_\_Comment 2 \_\_\_\_\_\_\_\_\_\_\_\_\_\_Comment 3 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/d/bd07429bea4d650129bfe8d97f4ab1ee98910482.png) ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [September 12, 2020, 12:22am UTC](https://forum.dynamobim.com/t/data-exported-from-dynamo-to-excel/55072/2 "2020-09-12T00:22:12Z")
I would group the values in Dynamo and join the like sets with a String.Join node, using a new line character as the joining value. This would join matching values into a single cell. Alternatively you could transpose your data and do a check on each item in the list to see if it is the same as the item proceeding it, and if so replace the value with a few dashes or a null value (which will be a blank cell in excel), and then transpose the data again.