So I have collected a lot of log data from some tools I have and it puts all the info in 2 columns with about 30,000 to 40,000 rows.
The data ranges are in 350 contiguous cells and then the next set up data starts - there are 4 sets of data and then the next measurement starts.
What I'd like to do is take the first 350 cells and copy them over to a new worksheet column, then the next 350 cells and paste them in the next column and do that for 4 columns
After this I'd like to rinse and repeat with cell 1401 (4 x 350) and do the next 4 columns and then repeat this cycle until the end of the data.
I'm not a VBA user by any extent, formulas would be nice or walk me thorugh a pivot table....
Example Data
PCI 20
PCI 20
\/ \/ (350 rows later)
EAF 5230
EAF 5590
\/ \/ (350 rows later)
SNR -11
SNR 3.95
\/ \/ (350 rows later)
RF 29
RF 38
This continues on for +30,000 rows - lots of data to parse manually....
Bookmarks