Forum Discussion
Information merged from a database
Good day,
I work for a city entity and we manage procurement detail daily. There is a tedious task I do where I know somewhere in excel there is an easier way to manage this information. Could you possibly assist? I will provide you an example of this information. What I am trying to do is change this information into columns for only a few of the rows, no all of them. For example columns listed as: Vendor Name, Address, Name of Contact, Email and then merge that information to those columns from the information we receive.
1 Reply
(for Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010)
Sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type a formula instead using the TRANSPOSE function. For example, in the following picture the formula =TRANSPOSE(A1:B4) takes the cells A1 through B4 and arranges them horizontally.
Transpose (rotate) data from rows to columns or vice versa
If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
Hope I was able to help you with this information.
I know I do not know anything (Socrates)
