How do I transpose a single vertical column with repeating sets of data to a multi-column view?
Hi all,
So I downloaded a list of purchases from an online site. The data is in a single column, each transaction has 7 rows of data.
I know how to transpose the 7 rows for each transaction to 7 columns, but the original data has over 20K rows. How do I transpose the data to a 7-column format for all 10k+ rows without having to do each set individually?
UPDATE: I'm using Excel 2016