I have a set of data I need to copy into excel. It looks like what you see below, except there are 500+ items. Further, I only need the "t" or "f" copied, and I would like them copied into a single column like this (but without the numbers).
1 F
2 T
3 F
4 F
5 T
6 T
The problem is that I need to do this for over 100 unique cases. So rather than typing every item in manually, how can I make Excel do this for me? Thanks so much for all your support!
Semper fi,
Paul
1 F 2 T 3 F 4 F 5 T 6 T 7 F 8 F 9 T 10 F
11 F 12 F 13 T 14 F 15 F 16 F 17 F 18 F 19 F 20 F
21 T 22 T 23 F 24 F 25 T 26 T 27 T 28 T 29 T 30 T
31 F 32 F 33 F 34 F 35 F 36 T 37 F 38 T 39 T 40 T
41 F 42 F 43 F 44 T 45 T 46 F 47 F 48 T 49 F 50 F
51 F 52 T 53 T 54 F 55 T 56 F 57 T 58 T 59 F 60 T
61 F 62 F 63 T 64 T 65 T 66 T 67 F 68 T 69 T 70 T
71 F 72 T 73 F 74 F 75 F 76 F 77 F 78 T 79 F 80 F
81 T 82 T 83 F 84 F 85 T 86 T 87 F 88 T 89 T 90 F
91 F 92 F 93 T 94 F 95 T 96 F 97 T 98 F 99 T 100 F
Bookmarks