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, 2022 in Others by Kithuzzz
• 38,020 points
1,299 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, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

When a row is added to one sheet, automatically add a row to another sheet

Use the VLOOKUP function. Your Spreadsheet 2's first column will ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,720 points
2,643 views
0 votes
1 answer
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, 2022 in Others by narikkadan
• 63,720 points
1,283 views
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, 2022 in Others by narikkadan
• 63,720 points
466 views
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, 2022 in Others by Edureka
• 13,690 points
926 views
0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

answered Jan 8, 2023 in Others by narikkadan
• 63,720 points
359 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, 2022 in Others by Edureka
• 13,690 points
3,489 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, 2022 in Others by Edureka
• 13,690 points
1,864 views
0 votes
1 answer
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 Nov 25, 2022 in Others by narikkadan
• 63,720 points
1,034 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