Linking rows to a column
Assuming you want to move the data from row to column:
1) Select all worksheets (click on the tab of the first one then press
CTRL+SHIFT+PGDOWN)
2) Select cells A1:X1 with the mouse
3) Press CTRL+C to copy
4) Click on cell A2
5) Choose Paste Special... on the Edit menu (ALT+e+s)
6) Check mark the Transpose option and click OK
7) Select the first row and delete it
Best,
Rafael
"Dan Evers" wrote:
I saw the post below about linking columns to rows, but am not smart enough
to adjust it to rows to columns. Example- Data in Sheet2, Rows A1-X1 need to
go to Sheet1, Columns A1-A26. I need to do this for about 24 sheets, so I am
too lazy to use the = function and manually input. Thanks in advance for the
help.
|