How to fix formatting issues in Excel after exporting survey data? | XM Community
Skip to main content
Question

How to fix formatting issues in Excel after exporting survey data?

  • August 24, 2020
  • 1 reply
  • 50 views

I exported my survey data to Excel, but my matrix questions turned into multiple columns when they should all be merged. How can I merge them?

1 reply

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 5940 replies
  • August 24, 2020

If you are using a newer version of Excel (Office 365 or 2019), you can use the TEXTJOIN function.


Leave a Reply