How do copy from a row to a column. I understand the transpose feature however i want the data to pull from the row across to the column down.
is there a character i can insert when copying formulas???
please help
How do copy from a row to a column. I understand the transpose feature however i want the data to pull from the row across to the column down.
is there a character i can insert when copying formulas???
please help
Hi,
Not sure I follow. This might help.
Say your data in Col A starting in A1 then enter this in B1 and drag across
=OFFSET($A$1,COLUMN(A1)-1,0)
To remove forumlas copy the range then paste special as values
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks