I need to deal with a file like below, to do further transform, I need to make all questions in one row。
From:
To:
I am not sure if it is possible, and I have tried another way, transform the file first, but I still need to split columns then append, like these:
From：
To：
Any one can help me to achieve my goal, please provide me some ideas.
BTW, since the real file is much more complex, there may be many questions and the answers can be in different format, I cannot use summary-concatenate-text to column to achieve my goal.
Really appreciate.
Joy
