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.
Cockatiel Reels Video Editor Category: Adobe Premiere Pro, Content Creation, Final Cut Pro, Instagram Marketing, Video Ads, Video Editing, Video Post Editing, Video Production, Video Services, Videography Budget: ₹600 - ₹601 INR
28-Mar-2026 17:03 GMT
High-Detail Product Renderings Needed Category: 3D Animation, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3ds Max, Blender, Cinema 4D Budget: $30 - $250 USD
Excel Workbook Cleanup for Football Stats Category: Data Analysis, Data Cleansing, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Excel Macros, Excel VBA, Visual Basic Budget: £10 - £20 GBP
28-Mar-2026 17:01 GMT
Secure AdSense Approval for Tech Blog Category: Content Strategy, Google Adsense, PHP, SEO, Web Design, Web Development, Website Optimization, WordPress Budget: ₹600 - ₹1500 INR
Interactive Excel Spreadsheet Development Category: Data Analysis, Data Analytics, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Visual Basic Budget: $250 - $750 USD
28-Mar-2026 16:52 GMT
Organic TikTok Follower Growth Category: Content Creation, Digital Marketing, Facebook Marketing, Growth Hacking, Internet Marketing, Social Media Management, Social Media Marketing, TikTok, Twitter, Video Editing Budget: $10 - $30 USD
28-Mar-2026 16:51 GMT
Build Power BI KPI Dashboards Category: API Integration, Data Modeling, Data Processing, Data Visualization, Excel, Microsoft Access, Power BI, Visual Basic Budget: ₹600 - ₹1500 INR
