Trouble pasting from web table into Excel on Mac

K

kbeilers

I'm trying to copy address data from a web table to Excel on my mac. The
problem is the data is somewhat transposed. Instead of keeping the columns at
the top, the data is grouped together in column A with a blank row in between
each set of data. Only column A gets populated. The transpose feature just
puts everyhing in row 1.

How do I copy and paste to keep the same layout as when I do that on a PC?

Thanks!!
 
J

JE McGimpsey

MacXL may interpret things like non-breaking spaces differently than
WinXL (I've never had the problem, but I tend to use web queries rather
than pasting from a web page).

If everything pastes into column A, try choosing Data/Text to Columns
and using the Text to Columns wizard separate your data.
 
Top