How to paste data in alternative columns?

[mahirrrr]

Hello,

please help me.

I have four tables that I need to put in one. I need to copy the whole table and paste it in every fourth column. So I would have First column from first table, First column of second table, First column of third table, First column of fourth table, Second column of first table, and so on, you get the point. Every table is an individual document.

I'm student and I use web version, this is for my thesis and I have like 400 tables that I need to combine in like 100 tables.


Thank you for your help.

 

[jasonb75]

With the web version you would have to copy and paste the individual columns one at a time. To automate the task would need vba which requires a full desktop version of excel.

 

[mahirrrr]

With the web version you would have to copy and paste the individual columns one at a time. To automate the task would need vba which requires a full desktop version of excel.

what is vba and how do I automate it?

 

[jasonb75]

Vba is a programming language that can be used to automate tasks with microsoft office applications.

Using it to automate your task would mean that a specific piece of code has to be written to match the layout of your tables. In order to write the code we would need more information regarding the layout.

To clarify what I said in my previous post, you will need a full desktop (windows / mac) version of excel to be able to use vba, it is not possible to use it with web, android or ios versions. Trial versions for desktop may also have limited functionality.