INDEX() function help

Peter Calvanelli

Hi,

I have a master list of tasks in one sheet with project specific labeled columns. I'd like to break out those columns into separate sheets. My thought is the best way to keep the master list current while transposing data, using a combination or INDEX() and MATCH() functions would be best but am interested in any suggestions.

Does anyone have any formula recommendations for transposing data to multiple sheets from a single data source?

Thanks.

David Tutwiler

I am sure there are multiple ways to do this, but I think DataMesh is a much more robust solution than the formulas you would have to maintain. I will provide the link for the DataMesh abilities below:

https://www.smartsheet.com/marketplace/premium-apps/datamesh