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.
Website Content Creation Category: Content Development, Content Strategy, Content Writing, Copywriting, Digital Marketing, Ghostwriting, Keyword Research, SEO, Technical Writing, Web Development Budget: $30 - $250 USD
17-Sep-2025 09:58 GMT
Project for Training Slide Redesign Category: Adobe Creative Suite, Branding, Brochure Design, Canva, Corporate Identity, Creative Design, Digital Design, Graphic Design, Logo Design, Visual Design Budget: ₹1500 - ₹12500 INR
17-Sep-2025 09:58 GMT
Realistic 3D Head Model Design Category: 3D Animation, 3D Design, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Blender Budget: $50 - $100 USD
17-Sep-2025 09:55 GMT
Design Home Organization App for Mothers Category: App Development, Graphic Design, Mobile App Development, PHP, UI / User Interface, User Experience Research, Web Development, Web Design Budget: $250 - $750 NZD