Forum Discussion
help with separating rows into columns
How can I separate data that is in rows into different columns? Note that in the picture you can see that some clients have more contacts than others. Any tips? Corey
Hi again,
If you ask me for my personal preference, I would go with method Five (Index, Columns, Rows Function) or Method Eight (Power Query)
However if you have Office 365 Insider then beyond a doubt Dynamic Arrays method Four takes 30 seconds to create.
Watch the different methods in my video tutorial here is the link another time (It's a one stop shop)
https://www.youtube.com/watch?v=tCTepTNxRqc
Good Luck
Nabil Mourad
nabilmourad - Hi Nabil, thanks for the link to your excellent videos. I'd like to use the index method, but the range of rows in the array varies from 4 to 7. dynamic arrays sounds useful, but I have Office 365 Personal, how do I add this method? In the meantime, I'll try power query, will reply later. Thanks
