can anyone help me with makin a three column table using a cells of single row.

Copper Contributor

hello everyone,
hope this message finds you in a good health and enthusiastic spirit. i am a student and need to perform data analysis very frequently. so i generally paste all of my data into a single cell followed by need to reorganise it into multiple columns and doing it with using single (preferable) or multiple formulas or with a string of customisable formulas will be very useful, convinient and time saving.
i have basic working knowledge of using xcel.
it would be very appreciable if anyone here can help me.

1 Reply


You could use WRAPROWS:

arr = A1:L1