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.
Customer Chat Response Setup Category: AI Chatbot Development, AI Content Creation, AI Text To Text, Automation, Chat Operation, Chatbot Integration, Customer Service Chatbot, Customer Support Budget: ₹750 - ₹1250 INR
22-Dec-2025 11:04 GMT
Logo and Gold Card Design Category: Adobe Illustrator, Photoshop, Branding, Card Design, Graphic Design, Illustration, Logo Design Budget: ₹600 - ₹700 INR
22-Dec-2025 11:03 GMT
Isometric Ingredient Assembly Animation Category: 2D Animation, 2D Animation Explainer Video, 3D Animation, 3D Modelling, After Effects, Animation, Graphic Design, Illustration, Video Editing, Visual Design Budget: ₹600 - ₹1500 INR
Professional AI Avatar Creation Category: AI Animation, AI Design, AI Text To Speech, Animation, Caricature & Cartoons, Graphic Design, Logo Design, Video Production Budget: $250 - $750 AUD
Indian ecom seller account and product listing handler Category: Amazon, Content Writing, Conversion Rate Optimization, Copywriting, Internet Marketing, Keyword Research, Product Descriptions, SEO Budget: ₹1500 - ₹12500 INR
22-Dec-2025 10:52 GMT
EBAY ACCOUNT BELOW STANDARD Category: Account Management, Content Writing, Customer Service, Digital Marketing, EBay, Market Research, Product Descriptions, SEO Budget: $30 - $250 USD
22-Dec-2025 10:51 GMT
PDF Text Conversion & Formatting Category: Data Analysis, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Microsoft Office, PDF Budget: ₹12500 - ₹37500 INR