Transpose ordered row data to column data

gcarmich

I have a .csv file with data grouped in rows and I need to transform it into column data format.  The data has no grouping data  other than it is separated by spaces in the file.  Can I transpose this data from rows to columns?

.csv attached

Thank you,
Gil

Book.csv

ChrisWaspe

Hi @gcarmich . With these types of problems always think Multi-Row Formula tool. You can use it to create a Group field. I also noticed there is a Date stamp. Please see how I have tackled this one. There are many similar approaches.

Transpose ordered row data to column data_cw.yxzp