Umair,

Reply to me privately, and I will email you an add-in that will transpose links. Take out the
spaces and change the dot to .

HTH,
Bernie
MS Excel MVP


"Umair Aslam" <Umair wrote in message
...
as we transpose values from rows to column in the same way i want to
transpose links from rows to column.is it possible in excel ?