Hi,
Select the data in column A and then Format Cells Alignment Uncheck
merge cells. This will demerge all cells. Now to plug in the holes so that
you can run a pivot, use the following trick:
1. Highlight the range in column A, say A5:A25;
2. Edit Go To Special Blanks;
3. Now perform the following
a. = key
b. up arrow
c. Ctrl+Enter
Hope this helps.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Johan" wrote in message
...
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