Forum Discussion

Quinten_L's avatar
Quinten_L
Copper Contributor
May 26, 2023

Transposing data from a column in one table to another on a different sheet

Hi,   I am having issues trying to get the formula to copy across the references in the direction I want them to. Please could you assist. I have a table ("stock") that has the names of stock it...
excel
Formulas and Functions
peiyezhu's avatar
peiyezhu
Bronze Contributor
May 27, 2023

Quinten_L 

 

when I add a new column to "projects".

 

As far as I know a fixed structure is easier to automate by computer rather than a table need adding new columns.

 

I also suggest pivot table to analysis data.

So transfer you columns to rows may be the first thing.

Resources