@xlncad: If your data

RE: RE: Need Help - How do I do this?

You are viewing a single comment's thread from:

RE: Need Help - How do I do this?

View the full context

xlncad(46)

Published in

Excel For All

Words

0

Reading

0 min

Listen

Play

2019-12-29 13:48

If your data is supposed to change you should go for an Array formula using TRANSPOSE function. The array formula for the example shown in the screenshot is
{=TRANSPOSE(B3:C14)}

Now about how to enter this formula.
Select the cells from G2 to R3, Type in the formula =TRANSPOSE(B3:C14) and press CTRL, SHIFT and ENTER keys together. A pair of braces will be added to your formula and the data present in the cells from B3 to C14 will be transposed into the selected cells.

Solution 1.PNG

One more example for your understanding

To transpose the data present in the cells B2 to G4 into the cells D7 to F12,
Select the cells from D7 to F12, Type in the formula =TRANSPOSE(B2:G4) and press CTRL, SHIFT and ENTER keys together.

Example 1.PNG

ecency

2019-12-29 13:48

xlncad(46)

via steemit

This post was published via steemit. Ecency is not the originator or editor of this content and displays it for discovery purposes only.

$ 0.281

5