Hi guys
I have some data, it's basically information on a table with 10 columns. When I paste it into excel it's just goes into the first column. I can transpose it to put it into a row, but is it possible to set it so that after 10 values, it continues on the row below?
Thanks
when you copy the data to paste into excel, paste it into the first cell, then when it occupies A1 and the rest of col A, then go to data tab, and text to columns and select delimited then space or comma if it is separated by a comma, then finish and it should populate across the number of columns you want.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks