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, sorry to restart an old thread, but I have a similar question but too many rows to use the copy, transpose method.
Is there a way to create a transpose function to use on a column (~20,000+ rows) that I need to transpose to rows?
I've tried the offset command but, some of the datasets are 4 rows, others are 7 rows.
Any ideas? Thanks in advance
Is there a way to create a transpose function to use on a column (~20,000+ rows) that I need to transpose to rows?
I've tried the offset command but, some of the datasets are 4 rows, others are 7 rows.
Any ideas? Thanks in advance
hello,
to answer your questions:
If you have a variable number of Columns and Rows then using the Index function will require a little bit more doing:
- You need to create a Defined Name using an Offset Function
- Use the Defined name you created for the Array argument of the INDEX function.
As for Office Insider, so long as you already have Office 365, then you can register for it at insider.office.com
Good Luck
Nabil Mourad