Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Demerge cells and copy data
Hi
I have the following sheet: A B Customer A Product 1 Product 2 Product 3 Customer B Product 1 Product 2 Product 3 Product 4 Total Column A is merged for every customer. How can i demerged with copying customer name to every cell so that I can use the data in a pivot table? Txs Johan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
demerge mercge cells | Excel Worksheet Functions | |||
Demerge Concatenate | New Users to Excel | |||
Copy data of two cells into one | Excel Discussion (Misc queries) | |||
Copy data of two cells into one | Excel Discussion (Misc queries) | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel |