I have a .csv file with 100000+ rows of output in two columns. The data is wave responses where column "A" repeats itself for evry 28th row, and column "B" holds responses that vary.
I want to use VBA to create a table that looks like what i have described later in this post. I have also atached a worksheet were I have started to created this table manualy, but I found this to time consuming.
Dir=0
Tz.....Response
6.......xxxxx
7.......xxxx
8.......xxxx
9.......xxxxxx
10.....xxxxx
.
.
.
Dir=15
Tz.....Response
6.......yyyy
7.......yyyyyy
8.......yyyyyy
9.......yyyyyy
10.....yyyyyy
.
.
.
.
Dir=30
Tz.....Response
6.......zzzzz
7.......zzzzz
8.......zzzzz
9.......zzzzzz
10.....zzzzzz
I want it to look something like this:
Tz...Dir=0....Dir=15....Dir30
6......xxxxx...yyyyyy...zzzzz
7......xxxxx...yyyyyy...zzzzz
8......xxxxx...yyyyyy...zzzzz
9......xxxxx...yyyyyy...zzzzz
10......xxxxx...yyyyyy...zzzzz
Bookmarks