Excel 2016 Transpose 1 Column into Separate Columns

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *