Forum Discussion
help with separating rows into columns
Hi,
You can use the Transpose feature.
Please check out this https://support.office.com/en-us/article/Transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419F2E3-BEAB-4318-AAE5-D0F862209744 and https://www.excel-easy.com/examples/transpose.html to learn more about it.
Hope that helps
- 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 advancehello,
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
Hi,
This might be automated using VBA or Power Query!
But I need the workbook or a sample of it to look into that!
Haytham Amairah , Hi Haytham, thanks, see attached file. Not sure where or how to save a working copy of a spreadsheet in this community....
