pcpavan108
New Member
- Joined
- Oct 15, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello,
I am a research student. I have huge data which i got by combining 100s of txt files into one excel workseet, main issue is: i wanted each of those text file's data to be arranged side by side instead of one below the other, is there any way i can do it.? Please help me with this.
I don't want to create hundred worksheets within a work book and then write VBA code where i can combine each of the worksheet's data into one worksheet side by side(so, in total 101 worksheet). But if you guys say thats the only way possible, then guide me with that too. Your help will be much appreciated. Thanks a lot.
I am a research student. I have huge data which i got by combining 100s of txt files into one excel workseet, main issue is: i wanted each of those text file's data to be arranged side by side instead of one below the other, is there any way i can do it.? Please help me with this.
I don't want to create hundred worksheets within a work book and then write VBA code where i can combine each of the worksheet's data into one worksheet side by side(so, in total 101 worksheet). But if you guys say thats the only way possible, then guide me with that too. Your help will be much appreciated. Thanks a lot.