excel training seminar - Transpose - link

Richard

Yes, trying to do this in Excel and trying to link the cells with the "=" sign - trying to link a vertical data series (column) into a horizontal data series (row)

Cheers
Nick

Richard

I think the word "link" is confusiung us here.

I am not referrring to hyperlinks - I am simply trying to establish a row of data (numbers) from a column of data (numbers). I can not however use the copy-paste transpose function as that only allows you to transpose 'values'

E.g. I want to recreate (link) the data in cells A1, B1, C1, D1, E1 ...... into B3, C3, C4, C5, C6......... using the "=" sign. I have hunders of rows of data so doing this manually will be a very time consuming task - is there a way of automating this function in excel??

What I need resolved should have a very simple solution, it is however difficult to explain - Is there a facility to attach a spreadhseet so that i can show you what I mean??

Cheers
NICK