Fixing an Excel annoyance using ChatGPT - rearranging tables
I found a helpful time saver that ChatGPT can do pretty well! If you copy data from a document/table online to Excel and it arranges itself into a single column instead of a table, put it in a LLM like ChatGPT first and tell it how to rearrange the data. I had to re-run prompt because there were random invisible values in the original data throwing off a few rows on the first run, but it was able to handle the task reasonably well with specific instructions on how to omit those (as with all juniors, double check its work before posting!).
Posted Jul 6, 2025, 7:38 PM UTC
77