Importing to Excel

[Jeremy_Long]

I am trying to connect data from a project to an Excel table and have been successful in doing so, but I can’t figure out how to keep the task description from creating addtional cells.

I have a list of “tasks” and a form to add new tasks, however those submitted by form have "This task was submitted through XYZ, [form link] in the description and it’s shifting the other cells when connecting to Excel.

I don’t see where this information is being pulled from in the Power Query Editor.

Any thoughts would be appreciated!

[Jeremy_Long]

I was able to solve this one myself, but I’m posting the information here so that if anyone else has this issue they will know what to do. The import function was picking up a comma from the description field and using it as a delimiter. I added a rule to the project that when a task is added via form it will change the task description to “.”