Split un-merged cell in to two cells

[joey1984]

Hi there,

I have many columns in my current spreadsheet but I have two columns that I want to split in to two project names.

Currently I have one column with: Project A/Project B
And the second column with the total cost of Project A AND Project B combined

The thing is that I can easily just create a new line but that would mean all the data in the other Cells remain the same and the only two that will be different are the above two columns. I will be maintaining alot of rows so I was hoping I do not have to create two rows for every new item then to merge both rows in reach column every time I have to put in a new Item.

I am hoping to have for example the below

Name Comments Project Cost
-------------------------------------------------
Item 1 This item relates Project A $150
to upgrade of Project B $120
SAS system
----------------------------------------------------

Currently I have it as

Name Comments Project Cost
-------------------------------------------------
Item 1 This item relates Project A/B $270
to upgrade of
SAS system
---------------------------------------------------

 

[jaybee3]

And how would you split the cost between the two projects?

 

[Andrew Poulsom]

If you want to do any analysis of your data you should have each item in its own row. You should avoid merged cells.