Hi,
Im new to the whole forum thing and im finding it really difficult to find the answer to my problem so i hope you people can help!!
Ok so i have a document that has 3 coulmns, 1 column of part number, the other of cost and a final column of total. like so:
Part No Cost Total
12345 12
12345 12
4567 5
4567 5
4567 4
This is a very simplified version i have thousands of part numbers sometimes there is 3 or more in a row and sometimes only 1, i have sorted the list via part number and my question is, is there a way of grouping the part numbers and cost, or even better creating a merged cell the length of the 3 part numbers that has a total? so in that case the two rows in the total column of part 12345 would be merged with the total cost across the two rows.
any ideas would be amazing!!
cheers
james
Bookmarks