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?
Answers
-
Hi,
You can use Sheet Summary for a range of the columns Sheet Summary | Smartsheet Learning Center
Best,
Beata
