Use SO with adjectives and adverbs
so + adjective/adverb + that + result
such + (adjective) + singular/plural noun + that + result
(It is common to put an adjective before the noun)
This is SUCH A good song that it stayed at number 1 for 12 weeks in a row. (notice the article in front of the singular noun)
The Andover Arms has SUCH good food that there's always a queue for a table.
SO / SUCH in exclamations
This is probably where most learners get confused.
In exclamations we drop the word 'that' and use:
i) such + noun (singular/plural)
ii) so + adjective