2.3 When exporting data to Excel, I wanted to transpose the sheet, however an error message said, that some fields were longer than 256 characters.

2.3 When exporting data to Excel, I wanted to transpose the sheet, however an error message said, that some fields were longer than 256 characters.

Hello,

I couldn't understand your query since we don't have an transpose option on exporting to Excel. Also the error is related to the capabilities of Excel. There are workarounds in excel to handle this error but these workarounds need manual manipulation of the file while using formulas. Here are some threads about the issue;

http://stackoverflow.com/questions/13202473/way-to-overcome-excel-vlookup-function-limit-of-256-characters

http://stackoverflow.com/questions/12386414/excel-use-formula-longer-that-255-characters

 

I hope this answer helps. Please don't hesitate to contact us for your further queries.

All the best!