Forum Discussion
Parse txt
Dear Expert, Could you please share how to parse the attached txt to Excel , So for example the ones underlined in read should be in one row and the second sub-headers in another ...
I think you're trying to accomplish this?
If so, you could use this:
=LET(
frame_subframe, CHOOSECOLS(data, {1, 2, 8, 9, 11, 12}),
vector, TOCOL(frame_subframe),
WRAPROWS(vector, 2)
)