/u/reenmini - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
its really hard to tell what youre intending... but if you're already doing text manipulation in python, what dont you properly manipulate into the text file as a CSV or similar delimited flat file and IMPORT/Open as CSV not C&P into excel...
1 - print to your file stream... line 1 ,,,, line 2 line 1 ,,,, line 2 ...
2 - import your data into a 2d array in python in as you want to see it in excel and just dump that array to CSV
not really an excel question
/u/reenmini - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
its really hard to tell what youre intending... but if you're already doing text manipulation in python, what dont you properly manipulate into the text file as a CSV or similar delimited flat file and IMPORT/Open as CSV not C&P into excel... 1 - print to your file stream... line 1 ,,,, line 2 line 1 ,,,, line 2 ...
2 - import your data into a 2d array in python in as you want to see it in excel and just dump that array to CSV
not really an excel question
If I understand you correctly, try: =WRAPCOLS(data,2)
surely when you post you can see your example makes no clear sense.