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.
Power Platform Certification Backend Build Category: Backend Development, Business Analysis, Data Integration, Data Modeling, Database Design, Database Management, Dynamic 365, PowerApps, Project Management Budget: $25 - $50 CAD
24-Jan-2026 22:50 GMT
Social Media On-Street Promoter Category: Digital Marketing, Facebook Marketing, Fashion Modeling, Lead Generation, Sales Promotion, Social Media Management, Social Media Marketing, Twitter Budget: €750 - €1500 EUR
24-Jan-2026 22:47 GMT
MBA Assignment Writing Support Category: Academic Writing, Business Writing, Finance, Management, Research, Research Writing Budget: $30 - $250 USD
