SOLVED

Copying data from a column to a row

%3CLINGO-SUB%20id%3D%22lingo-sub-2280796%22%20slang%3D%22en-US%22%3ECopying%20data%20from%20a%20column%20to%20a%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280796%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20Excel%20question.%20I%20have%20data%20in%20cells%20in%20a%20column%20that%20are%20the%20product%20of%20a%20calculation%20using%20data%20from%20cells%20in%20other%20columns%20in%20the%20same%20worksheet.%20I%20want%20to%20copy%20the%20selected%20cells%20from%20the%20column%20to%20a%20series%20of%20cells%20in%20one%20row%20on%20the%20same%20worksheet.%20I%20want%20the%20cells%20that%20are%20copied%20to%20the%20row%20to%20be%20linked%20to%20the%20cells%20in%20the%20column%20so%20that%20a%20change%20in%20the%20value%20of%20a%20cell%20in%20the%20column%20is%20automatically%20changed%20in%20the%20corresponding%20cell%20in%20the%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20use%20the%20Copy%20and%20Transpose%20function%20but%20it%20doesn't%20seem%20to%20work%20in%20the%20situation%20where%20the%20cell%20value%20is%20a%20product%20of%20a%20calculation.%20Is%20there%20a%20way%20I%20can%20do%20this%20without%20doing%20a%20Copy%20and%20Link%20one%20cell%20at%20a%20time%3F%20I%20have%20attached%20a%20sample%20spreadsheet%20to%20illustrate%20the%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20MS%20365%20Family%20on%20a%20Windows%2010%20PC.%20As%20a%20note%2C%20my%20level%20of%20Excel%20expertise%20is%20modest!%3C%2FP%3E%3CP%3EThanks%20for%20any%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280796%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281511%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20data%20from%20a%20column%20to%20a%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281511%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHans%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMagic!%20Thanks%20so%20much%20for%20your%20quick%20response!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20Mike%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280841%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20data%20from%20a%20column%20to%20a%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1033088%22%20target%3D%22_blank%22%3E%40iowamjm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20A27%3AS27.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%20%3DTRANSPOSE(F3%3AF23)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Greetings!

 

An Excel question. I have data in cells in a column that are the product of a calculation using data from cells in other columns in the same worksheet. I want to copy the selected cells from the column to a series of cells in one row on the same worksheet. I want the cells that are copied to the row to be linked to the cells in the column so that a change in the value of a cell in the column is automatically changed in the corresponding cell in the row.

 

I have tried to use the Copy and Transpose function but it doesn't seem to work in the situation where the cell value is a product of a calculation. Is there a way I can do this without doing a Copy and Link one cell at a time? I have attached a sample spreadsheet to illustrate the question.

 

I am using MS 365 Family on a Windows 10 PC. As a note, my level of Excel expertise is modest!

Thanks for any help.

 

2 Replies
best response confirmed by iowamjm (New Contributor)
Solution

@iowamjm 

Select A27:S27.

Enter the formula =TRANSPOSE(F3:F23)

@Hans Vogelaar 

 

Hans,

 

Magic! Thanks so much for your quick response!

 

Regards, Mike