Hi,
I need to impot a huge amont of data from txt to excel.
My problem is that I need to organize it in rows instead of coloums.
I have information of a lot of profiles and I need to put it side by side :
Actual output (importing from txt file):
[profile 1 6x6]
[profile 2 6x6]
[profile 3 6x6]
....
Wanted output:
[profile 1 6x6] [profile 2 6x6] [profile 3 6x6] .....
Regards,
Miguel
Can you import it, then do a Copy then PasteSpecial using "Transpose" ? Does that work?
Assuming you mean the profiles are in 6 cell x 6 cell data tables vertically, and you want them horizontally, you could use VBA to transpose... or, in cell G1 enter...
Formula:
=INDEX($A:$F,INT((COLUMN()-1)/6)*6+ROW(),IF(MOD(COLUMN(),6)=0,6,MOD(COLUMN(),6)))
...then copy down and right 6 cells (inclusive), then use fill handle to copy 6x6 to right as far as needed (format as desired before doing this step). Once you have all the data horizontally, select it all, copy and paste values in place (or if you have to do this again for new data, paste values to new/blank sheet/workbook).
Last edited by jhren; 07-25-2013 at 04:41 PM.
Edited G7 to G1.Originally Posted by jhren
Last edited by jhren; 07-25-2013 at 04:42 PM.
The problem is that the matrix data from profiles vary in dimensions (sometimes 8x6 others 7x6).
I can't use transpose because I want the data oganized side by side (horizontally) with the same configuration for each profile.
Do you mean each data set has different profile dimensions? ...or within each data set each profile's dimensions vary?
If the former, the formula can be changed to accomodate.
If the latter, you will have to identify a unique characteristic which can be used to trigger the "offset". An example file would help (replace sensitive info with fake data)...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Miguel7799 
Register To Reply
Bookmarks