Data Evaluation: Merging, Joining, and Combining Some Row Columns

JBrumer

Hello,

I’m in the process of creating a grid and eventually a dashboard in order to evaluate data from years and months. Right now, I’m working with two rows: Row 1 and Row 2. Here’s what I’m aiming to do:

• In Row 1 (columns A-L), I want to merge the columns for the year 2021, and in columns M-X, I want to merge the columns for the year 2022.
• In Row 2, I want to list the months (January to December) in each respective column, repeating as necessary.

Is there a SmartSheet function, formula, or method that would allow me to merge the column in Row 1 in this way?

Example.PNG

Yvonne Smythe

Hi @JBrumer - Do you have access to the Smartsheet Pivot App? I’ve used it before to create this set up. Hope this helps.

https://help.smartsheet.com/articles/2476736-get-started-pivot

JBrumer

I was not familiar with that, and will look into it. Thank you @Yvonne Smythe

Yvonne Smythe

@JBrumer You’re welcome.