arranging data side-by-side

[pcpavan108]

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.

 

[Peter_SSs]

Welcome to the MrExcel board!

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

I suggest that you use XL2BB to provide some small dummy samples of your data and the expected results.