help with separating rows into columns

ccorey05 

Hello,

There are Eight methods to switch columns into rows. before picking up the technique that works best for you out of the EIGHT methods you have to ask yourself some questions:

1. Do you want it to be dynamic or static (does not refresh when source data changes)
2. Do you have Office 365 Insider (you can then use the TRANSPOSE function without CTRL+ SHIFT + ENTER
3. Do you like using Power Query? it's easy to refresh
4. Do you prefer classic functions?

I am going to show you the EIGHT techniques and it's up to you to select the one that works best for you. I therefore created a video tutorial showing and comparing the eight methods. You can also download the sample file I used for my recording

https://www.youtube.com/watch?v=tCTepTNxRqc

The techniques I used are:

1. Paste Special >>Transpose
2. Shortcuts
3. Transpose Function with CTRL+SHIFT+Enter
4. Transpose Dynamic Array Function (only Office 365 Insider)
5. Index, Columns & Rows Functions
6. CHAR & INDIRECT functions
7. Find & Replace method
8. Power Query (can be automatically Refreshed)

Let me know which technique you like most.

Best of luck with your project

Nabil Mourad