I have an Excel spreadsheet with repeating columns.

Options
Kim L
Kim L
edited 03/22/24 in Smartsheet Basics

I imported an Excel spreadsheet that has 3 columns that repeats several times. What is the best way for me to convert the columns to rows so that I can use the COUNT function? or is there a way to total up items in columns?

Answers