I need to know how to take data (in Excel 2016) in one column (with many rows) and split it into 7 columns, keeping the order of the data. I already created a new column (A) to show how I need it organized. A 23 B 46 C 23 D 34 E 68 F 57 G 95 A 34 B 85 C 61 D 93 … I need the A,B,C,D,E,F,G in column A to become the columns. Here is what I need it to look like, but repeated: A B C D E F G 23 46 23 34 68 57 95 43 85 61 93 …

By: Cynthia