Sign in to join the conversation:
i.e. if a cell looks like
A
B
C
How to get A, B and C into separate cells?
Hi myi,
You've got two ways to do this:
Is there a reverse to this solution? Say I have multiple rows that I want to have linked into a single cell.
Yes if you use this formula. =[column name]@row + " " + [column name]@row. You can do this for 2 cells for sure. Unsure if more than that. In the cell you want the data to merge do = then click on the cell with the first set of data. Add a + sign. Then add + and click the second cell. The + sign pulls them together. If you require a space or other identifier between the data " " puts a space between the two or add in your identifier between the " ". We used this to combine first and last names from a data import. If you then right click the cell and annotate it to be a column Fx it will continue to do that for the entire sheet. Hope this helps.
I inserted a dashboard in our staff portal (Sharepoint). There is a header I do not see when I am in the Dashboard. It appears when inserted onto a webpage. How can I hide it?
I am wanting to send a request for an update to our inventory control people when we have non-conforming material that needs to be contained in the system and physically. I have a column for each with a drop down of Yes, No,N/A. I have my automation setup for triggered when containment required changes to any value,…
I'd like to be able to enter a unique value in a form and have it prepopulate a few other areas of the form. For example, I'd like to enter an employee ID number in the FORM, and once entered the First and Last Name sections of the FORM would automatically populate with the correct information.
