Transpose column on one sheet to row on another with linking

0 votes
In worksheet A, let's say A1:A10, I have a column of data. I have a range of data from A1 to J1 in worksheet B. I require a data transposition from worksheet A's column to worksheet B's data range. I can use Paste Special to insert the values, but I need worksheet A's data to automatically update worksheet B's data.
Sep 24 in Others by Kithuzzz
• 20,660 points
50 views

1 answer to this question.

0 votes

select A1:J1 in worksheet B and enter:

=TRANSPOSE('worksheet A'!A1:A10)  

with Ctrl+Shift+Enter.

answered Sep 25 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to keep one variable constant with other one changing with row in excel

Use this form: =(B0+4)/$A$0 Since you are dragging across ...READ MORE

answered Nov 24 in Others by narikkadan
• 37,660 points
23 views
0 votes
0 answers
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
106 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
140 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
236 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
69 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered 6 days ago in Others by narikkadan
• 37,660 points
15 views
0 votes
1 answer

Excel create an Index on the first sheet with links to subsequent sheets

This seems to be a potential duplicate ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
45 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP