Trouble pasting from web table into Excel on Mac

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to transpose data (Row to column) without losing the cell link 3
Worksheet Merge Excel Mac 2004 1
VBA - retrieve data on last create named range from previous inserted named range 0
Transpose, Paste Special 2
"Paste Special / Transpose" problem 3
Splitting a cell into rows instead of columns 12
Copy and Paste cells limitation 4
Pasting /transposing from rows to columns. 1

Back
Top