I have an Excel spreadsheet with repeating columns.

Kim L

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?

SmartWay360

Hi,

You can use Sheet Summary for a range of the columns Sheet Summary | Smartsheet Learning Center

Best,

Beata