Copying & pasting data — Google Sheets

how do i paste data that is not in excel/sheets format, without it being pasted into 1 single box or even 1 single row? if not possible, is there a way i can highlight certain data and shift it over(paste) to the next column (to the right) without having to manually copy and paste it? EX. I have data from a PDF file and everytime I paste it the best i can do is have them separated in the vertical column, but not the horitzontal.

Wow. Great job. Thanks for your help.

why are these programs so fucking difficult and non user friendly fucking hell holy fuck!!!!!

all i want to do is paste my data across the fucking page

my whole table pastes in 1 column. I'm coyping it from a weird site (jungle scout) so it's maybe a javascript or something table idk...i just can't get it to paste right :(

thank you sir this really helped me out :)

my problem is how can I copy and paste for 30,000 columns?

Sooooooo helpful! Thank you sir!

Excellent , only person to mention that feature, thank you

Copying and pasting somehow fucks it up for me

Thank you so much!

Sir how to paste the same text in multiple cells

Thx

Thank you, Thank you!!

its so nice to hear clean english accent

hi sir, would you please inform me how to paste comment from microsoft excel into gsheet? thank you

thank u sir! very helpful--do u also know how to import data that's solely text separated by commas?