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.
Long-Term Text Data Entry -- 2 Category: Data Cleansing, Data Collection, Data Entry, Data Management, Data Processing, Excel, Google Sheets, Web Scraping Budget: $250 - $750 USD
US Coding Influencer Leads Category: Data Analysis, Data Collection, Data Entry, Data Mining, Excel, Google Sheets, Influencer Marketing, Leads, Research, YouTube Budget: £5 - £10 GBP
Daily FMCG Social Content Category: Adobe Creative Cloud, Canva, CapCut, Content Creation, Facebook Marketing, Graphic Design, Social Media Marketing, Video Editing Budget: ₹600 - ₹1500 INR
18-Dec-2025 11:00 GMT
Elementor Site Speed Boost Category: CSS, Elementor, HTML, Performance Tuning, PHP, Web Development, Web Design, Website Optimization Budget: ₹12500 - ₹37500 INR
18-Dec-2025 11:00 GMT
Danish Text-to-Speech SaaS Booking System -- 2 Category: AI (Artificial Intelligence) HW / SW, AI Text To Speech, Coding, JavaScript, PHP, Python, Software Architecture, Web Development Budget: $750 - $1500 USD