In a blank cell C1, please enter this formula: =OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*5,0), and then drag the fill handle from C1 to G1, see screenshot: In excel, the OFFSET function can help you, you can use this formula as following steps:ġ. Transpose a single column to multiple columns with Kutools for ExcelĬonvert a single column to a range of data from row to row: Transpose a single column to multiple columns with formulas Here we will show you some tricky things about how to change a single column into multiple columns. Supposing you have a table as showing below, and you need to change one column to a range. A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.How to transpose / convert a single column to multiple columns in Excel? And let’s not forget all the great new Apps & services available. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. I did a similar challenge with Office 365, blogs can be found here. I won’t just be talking about the new Microsoft 365 subscription model. Purpose of this blog challenge: I will write 365 blogs in 365 days around Microsoft 365. It is also possible to copy and paste tables of data in the same way: PLEASE KEEP THIS IN MIND WHEN USING MY BLOGS AS GUIDELINES.Īll you have to do is select the data (1), Right-click > Copy (2), Right-click > Paste Special (3), Transpose (4). CONTENT IS ACCURATE AT TIME OF PUBLICATION, HOWEVER UPDATES AND NEW ADDITIONS HAPPEN DAILY WHICH COULD CHANGE THE ACCURACY OR RELEVANCE. DISCLAIMER: I WRITE ARTICLES ABOUT OFFICE / MICROSOFT 365. This is very easy to accomplish with Paste Special – Transpose.įor previous posts in my #Microsoft365Challenge go to the index page. #Microsoft365 – Ever need to change data in Excel displayed as columns to rows? No retyping necessary.
0 kommentar(er)
