VLOOKUP FOR 160+ COLUMNS

Archie Villa

Hello Everyone

1. I have created a form with 160+ questions in it
2. then it was summarized in sheets ( see attached "FORM.png")
3. Now that i have those answers , i want them to be summarized in another sheet in rows since the answers have corresponding points to it (see attached "row.png").
y questionisre:. is there a way i could do it the faster way similar to a "transpose" function in excel?

Andrée Starå

Hi @Archie Villa

The easiest method I've found for transposing is to export to excel and make the changes and then import it back to Smartsheet.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Archie Villa

Andrée Starå

Hi @Archie Villa

The easiest method I've found for transposing is to export to excel and make the changes and then import it back to Smartsheet.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Archie Villa

Thank you Andree

Actually it was my last resort to export it in excel them import it again, a bit tasky, but it is much easier.

Appreciate your assistance.

Regards

Archie

Andrée Starå

@Archie Villa

Happy to help!