I have a text file composed of grouped lines. Actually, each group is a single record split on different lines (it’s a system log file) and I need to analyze that data, but in order to do that, I need to transpose each group in a single row.
The number of lines for each group may vary from 1 to 3, but this number is not fixed.
Googling didn’t help me to straighten this odd format with PQ.
Can you please help?
group transpose.xlsx (20.7 KB)