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 Travel Itinerary App Category: AI Development, AI Mobile App Development, Android, App Design, Graphic Design, IOS Development, IPhone, Mobile App Development Budget: ₹75000 - ₹150000 INR
23-Jul-2025 16:03 GMT
Kintone Workflow Automation Specialist Category: API Development, CRM, Data Management, Database Management, Excel, PHP, Software Architecture, Software Development Budget: $25 - $50 USD
Figma Website Messaging Update Category: Figma, Graphic Design, UI / User Interface, User Interface / IA, Visual Design, Web Design, Web Development Budget: $10 - $30 USD
23-Jul-2025 16:00 GMT
Elementor Column Layout Customization Category: CSS, Elementor, Graphic Design, HTML, PHP, UI / User Interface, Web Design, Web Development, WordPress Budget: $30 - $250 USD
23-Jul-2025 15:59 GMT
A matrimonial cum dating website and apps Category: App Development, Database Management, Graphic Design, HTML, Mobile App Development, PHP, Web Development, Web Design Budget: ₹12500 - ₹37500 INR
Marketing digital and others Category: Advertising, B2B Marketing, Internet Marketing, Leads, Mailchimp, Marketing, Sales, SEO, Social Networking, Telemarketing Budget: $8 - $15 USD
23-Jul-2025 15:57 GMT
King Kong Hero Graphic Design Category: HTML, UI / User Interface, Web Design, Web Development, WordPress, WordPress Design Budget: $10 - $30 AUD
23-Jul-2025 15:57 GMT
Ustazi Mobile Application Category: Android, App Design, Chatbot, Database Management, Flutter, Google Firebase, IOS Development, IPhone, Mobile App Development, UI / User Interface Budget: $1000 - $2400 USD
