I want to create a table of data with information about vehicles.
The headings for this table can be found in Sheet2 of the attached spreadsheet.
I would be pasting data into Sheet1 that I would want to be transferred to Sheet2.
As you can see the data in Sheet1 would be pasted into a single column.
I'd like a button that copies, pastes and transposes the data in Sheet1 into a table on Sheet2.
Potentially there will be hundreds of rows in the table on Sheet2.
I will be copying the data into Sheet1 from a website and it comes out in this single column format.
So I would be overwriting the data in Sheet1 many times and would need it to add a new row to the table in Sheet2 every time I press the button.
AI Voice Skincare Advisor Category: AI (Artificial Intelligence) HW / SW, AI Chatbot Development, AI Content Creation, Audio Services, Education & Tutoring, Natural Language Processing, Research Writing, Voice Talent Budget: $15 - $25 USD
26-Nov-2025 11:02 GMT
Roblox City-Building Game Development Category: Game Design, Game Development, Game Testing, Java, Lua, Roblox, Scripting, Unity 3D Budget: $250 - $750 USD
Complete Rock Song Production Category: Audio Editing, Audio Production, Audio Services, Music, Music Production, Sound Design Budget: $10 - $30 USD
26-Nov-2025 11:00 GMT
YouTube Vlog Cinematic Editor Category: Adobe Premiere Pro, After Effects, Audio Editing, Color Grading, DaVinci Resolve, Final Cut Pro, Post Production, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR