Apologies, yes that did work Thank you again, your service has been extremely helpful!
mrice, you are very helpful and for that I thank you; however not to keep bothering you about this topic, is it possible to expand on this i.e. if there are multiple IDs: if.... ID.....Region 1.....Region 2.....Region 3.....Channel 1.....Channel 2 1...........X...........................................X.....................X......................X 2..................................X....................X.....................X then... ID Region Channel 1 Region 1 Channel 1 1 Region 1 Channel 2 1 Region 3 Channel 1 1 Region 3 Channel 2 2 Region 2 Channel 1 2 Region 3 Channel 1 And so on if additional IDs are added
Thank you for the response http://www.excelforum.com/excel-prog...ml#post2436458 However I am having difficulty executing the macro, could you please help? I have the initial table beginning in cell a1 (entire table: 2r x 6c) Thank you, John
