Hi guys,
I have an Excel file with one row and more than 2000 columns. Can someone explain me how can I turn this into one single column/cell? Basically turn a table 1X2000 to a 1X1.
Thanks in advance.
Printable View
Hi guys,
I have an Excel file with one row and more than 2000 columns. Can someone explain me how can I turn this into one single column/cell? Basically turn a table 1X2000 to a 1X1.
Thanks in advance.
Select the lot.
Use the excel function transpose
A quick google search gave the link above...
Thanks Ecniv!
no problem.
If this resolves the question, at the top of your original post should be a thread tools. Select it and select mark as resolve :)
Have a great day!