Transposing a single column of data in Excel with a set number of columns
I was faced with an interesting challenge, I was tasked to provide a list of all the sites available via our O365 subscription, but I was not given sufficient access rights to navigate to the administration portal to pull this list. In fact, this is the only view I had available to me: Selecting, copying and pasting the content into Excel seems like the obvious next step, but alas, I was faced with one column of data with all the information that appeared in my view, i.e. the site title, the news title, the news synopsis the author and the modified date. All I want was the site title. After cleaning up the Excel a bit, I noticed that the information that I wanted appeared in every 4 th row. Meaning that if I could somehow transpose this single column of data into a grid with 4 columns, I will easily get the information I want. Unfortunately, this type of transpose function does not exist in Excel. After a little googling and tweaking I fi...