excel forum example.xlsI am just beginning to work with VBA and macros. I do not yet know the language. I have so far been able to bring in data from an email and save as a text file. From the
text file I bring in the data into column E (starting at E5) and downward (never a fixed length). The info in columns G & I is the end result that I want. Is this really a "transpose"? Or what sort of formula/command do I need to make the entire E column (always a different amount of data) go to the G & I columns? I would think it needs to loop until it reaches the last cell in column E that contains data. Thank you for your suggestions and help!
A B C D E F G H I
77.50 NAME
77.50 0.31 NAME
NAME 88.25 NAME
0.31 84.59 NAME
NAME 62.20 NAME
88.25 100.00 NAME
NAME 103.40 NAME
84.59 140.00 NAME
NAME 66.69 NAME
62.20
NAME
100.00
NAME
103.40
NAME
140.00
NAME
66.69
NAME
Bookmarks